Search Results
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-priority-queue.html
MySQL HeatWave uses a workload-aware, priority-based, automated scheduling mechanism to schedule concurrently issued queries for execution. The scheduling mechanism prioritizes short-running queries but considers wait time in the queue so that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Before You Begin Complete the steps to load data using Auto Parallel Load or manually. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format. For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL HeatWave. The rpd_tables table has these columns: ID A unique identifier for the table. The SCN is an internal number that represents a point ...