Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of execution statistics is stored for each node that participates in the query. For MySQL HeatWave AutoML routines that include ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-0.html
For more information, see Bulk Ingest Data Type Support (WL #16510) MySQL HeatWave now supports the use of the ANALYZE TABLE statement to update statistics for tables loaded into the MySQL HeatWave Cluster. This enhancement improves query ... Note ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
You can also add statistics for the time and size of the queries performed. In addition to the overall buffer pool usage, workload activity, and access patterns, Auto Shape Prediction now utilizes the CPU statistics to estimate the required buffer ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-26: Data Storage Size Can Now Be Increased For Highly Available DB Systems You can now increase the data storage size of a highly available DB System ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
To get the optional query statistics available from that release, you set them up as a filter using the service component, which implements the services that write the statistics to the audit log. For instructions to set this filter up, see Adding ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-innodb_cmp.html
These two tables have identical contents, but reading from INNODB_CMP_RESET resets the statistics on compression and uncompression operations. For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logging-management-commands.html
Table 25.26 Cluster log categories, with default threshold setting Category Default threshold (All data nodes) STARTUP 7 SHUTDOWN 7 STATISTICS 7 CHECKPOINT 7 NODERESTART 7 CONNECTION 8 ERROR 15 INFO 7 BACKUP 15 CONGESTION 7 SCHEMA 7 The STATISTICS ... ndb_mgm supports a number of management commands related to the cluster log and node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
Ndb_fetch_table_stats: Number of times table statistics were fetched from tables rather than cache. ndb_index_stat_option: Comma-separated list of tunable options for NDB index statistics; list should contain no spaces. The following list includes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-top.html
Each thread is represented by two rows in the output, the first showing system statistics, the second showing the measured statistics for the thread. The program tries to obtain statistics from a data node having the node ID given by the --node-id ... ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data ...