Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations.html
The following limitations apply to Lakehouse. For MySQL HeatWave limitations, see Section 11.2.1, “MySQL HeatWave Limitations”. ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations.html
This section lists functionality that is not supported by MySQL HeatWave. It is not an exhaustive list with respect to data types, functions, operators, and SQL modes. For data types, functions, operators, and SQL modes that are supported by MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-memory-usage.html
To view the memory usage for each MySQL HeatWave node: mysql> SELECT ID, MEMORY_USAGE, MEMORY_TOTAL, BASEREL_MEMORY_USAGE FROM performance_schema.rpd_nodes; +----+--------------+--------------+----------------------+ | ID | MEMORY_USAGE | ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-node-status.html
To view the status of each MySQL HeatWave node: mysql> SELECT ID, STATUS FROM performance_schema.rpd_nodes; +----+---------------+ | ID | STATUS | +----+---------------+ | 0 | AVAIL_RNSTATE | | 1 | AVAIL_RNSTATE | +----+---------------+ For column ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries.html
This section provides Information Schema and Performance Schema queries that you can use to retrieve MySQL HeatWave metadata. Note For queries that monitor MySQL HeatWave node status, memory usage, data loading, change propagation, and queries, see ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-misc-functions.html
Table 5.13 Miscellaneous Functions Name Description ETAG() Compute hash for each row, using one or more column or other values. What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-option-tracker.html
The Option Tracker component provides usage information about different features and components of MySQL HeatWave. As of MySQL 9.2.1, the boolean flag used has been replaced with an integer flag usedCounter in the option_tracker_usage_get() and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. Use SQL queries to access this data and check the system status and performance. The Auto Shape Prediction feature in MySQL HeatWave Autopilot uses MySQL statistics ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-schema-tables.html
MySQL HeatWave Performance Schema tables provide information about MySQL HeatWave nodes, and about tables and columns that are currently loaded in MySQL HeatWave. Information about MySQL HeatWave nodes is available only when rapid_bootstrap mode is ...