Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
row *************************** query_id: 14 LEFT(query_text,160): SELECT country from airport_geo *************************** 2. row *************************** query_id: 15 LEFT(query_text,160): CREATE TABLE flight_from_US SELECT * FROM flight ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
TRX_WEIGHT The weight of a transaction, reflecting (but not necessarily the exact count of) the number of rows altered and the number of rows locked by the transaction. Transactions that have changed nontransactional tables are considered heavier ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
The size of the list is controlled by the profiling_history_size session variable, which has a default value of 15. The LIMIT row_count clause may be given to limit the output to row_count rows. If LIMIT is given, OFFSET offset may be added to begin ...Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
Diagnostics Area Structure Diagnostics Area Information Items How the Diagnostics Area is Cleared and Populated How the Diagnostics Area Stack Works Diagnostics Area-Related System Variables Diagnostics Area Structure The diagnostics area contains ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
It happens that these system columns are the row ID, the transaction ID, and the rollback pointer, but their values don't matter now. Helpful Notes About "Field Start Offsets": Notice that the sizes of the record's fields, in forward order, are: 6, ... The Field Contents part of the record has all the ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
mysql> SELECT CHAR(77,121,83,81,'76'); +--------------------------------------------------+ | CHAR(77,121,83,81,'76') | +--------------------------------------------------+ | 0x4D7953514C | +--------------------------------------------------+ 1 row ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
When loading multiple compressed files, it is best to prepare files of similar size, and in the range of 80-120 MB each. mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv", ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. Other tables that contain transaction event rows are logically ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
It is autosized by default; to configure the table size, set the performance_schema_max_metadata_locks system variable at server startup. When a metadata lock is requested and not obtained immediately, a row with a status of PENDING is inserted.
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
You can load data into a MySQL HeatWave Cluster by using the Auto Parallel Load feature. Auto Parallel Load, which can be run manually from any MySQL client or connector, is implemented as a stored procedure named heatwave_load, which resides in ...