Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Compression Per Index Enabled Enables per-index compression-related statistics in the INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX table. Stats Auto Recalc Enabled Causes InnoDB to automatically recalculate persistent statistics after the data in a table ... Lists the InnoDB Configuration configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In addition to the introduction of views on data dictionary tables, table statistics contained in the STATISTICS and TABLES tables is now cached to improve INFORMATION_SCHEMA query performance. The information_schema_stats_expiry system variable ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
LogLevelStatistic Version (or later) NDB 8.4.0 Type or units integer Default 0 Range 0 - 15 Restart Type Node Restart: Requires a rolling restart of the cluster. (NDB 8.4.0) The reporting level for statistical events such as number of primary key ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-menus-navigation-sidebar.html
For example, the Metrics menu, User Statistics, is displayed only if a MySQL instance is selected, not if a host, agent, or All Targets is selected Overview Overview: opens the Overview dashboard. This report enables you to view detailed table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
Table statistics are updated only for DELETE or UPDATE operations that modify indexed columns. Statistics are not updated by operations that modify only nonindexed columns. ANALYZE TABLE clears table statistics and sets the STATS_INITIALIZED column ... The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
If this variable is 0, the Performance Schema does not maintain connection statistics in the accounts table or status variable information in the status_by_account table. If this variable is 0, the Performance Schema does not maintain connection ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
The number of entries permitted in the statistics cache by default is 65536, which is enough to store statistics for 4000 to 5000 unique queries of medium complexity. By injecting actual statistics from previous query executions into subsequent ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a new query shares query execution plan nodes with previously executed queries, the statistics ...Each entry in the cache corresponds to a query execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
Only this format supports the optional query time and size statistics. Adding Query Statistics for Outlier Detection In MySQL 8.4, you can extend log files in JSON format with optional data fields to show the query time, the number of bytes sent and ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...