Search Results
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE TABLE generates table statistics: ANALYZE TABLE without any HISTOGRAM clause performs a key distribution analysis and stores the distribution for the named table or tables. ANALYZE TABLE with the UPDATE HISTOGRAM clause generates histogram ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The optimizer can make row estimates using index dives or index statistics. If eq_range_index_dive_limit is greater than 0, the optimizer uses existing index statistics instead of index dives if there are eq_range_index_dive_limit or more equality ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3551; Symbol: ER_UNABLE_TO_STORE_STATISTICS; SQLSTATE: HY000 Message: Unable to store dynamic %s statistics into data dictionary. Error number: MY-011007; Symbol: ER_DD_UPGRADE_FAILED_TO_CREATE_TABLE_STATS; SQLSTATE: HY000 Message: ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Only this format supports the optional query time and size statistics. JSON format is the only audit log file format that supports the optional query time and size statistics. To add the query statistics to the log file, you must set them up as a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
STATS_AUTO_RECALC Specifies whether to automatically recalculate persistent statistics for an InnoDB table. The value DEFAULT causes the persistent statistics setting for the table to be determined by the innodb_stats_auto_recalc configuration ...| ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
See Also column, composite index, index, index hint, persistent statistics, random dive, selectivity, unique constraint. Statistics about latch use and contention are available through the Performance Schema interface. persistent statistics A ...
https://dev.mysql.com/doc/workbench/en/wb-performance-reports.html
Reports help analyze IO hotspots, discover high cost SQL statements, and review wait statistics and InnoDB engine metrics. High Cost SQL Statements Statement Analysis – Lists statements with various aggregated statistics. Database Schema ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ON. Updating Table ...Check if you have the SELECT and INSERT privileges for the table that you want to ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Examples: ANALYZE TABLE fails because it updates table statistics, which are stored in the data dictionary. INFORMATION_SCHEMA tables in MySQL 8.4 are closely tied to the data dictionary, resulting in several usage differences: Previously, ... Use ...