Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-statistics-table.html
For information about histogram statistics, see Section 10.9.6, “Optimizer Statistics”, and Section 15.7.3.1, “ANALYZE TABLE Statement”. The COLUMN_STATISTICS table provides access to histogram statistics for column values. You can see ...
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/information-schema-innodb-ft-config-table.html
The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------------------+ | ... The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
When a table with instantly added or dropped columns is rebuilt due to a table-rebuilding ALTER TABLE or OPTIMIZE TABLE operation, the value is reset to 0. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This information is derived from in-memory data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
It does not provide information about internal InnoDB temporary tables used by the optimizer. The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact. Each row in this table corresponds to an individual partition or subpartition of a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
For information about optimizing this behavior, see Section 17.8.3.3, “Making the Buffer Pool Scan Resistant”, and Section 17.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”. The buffer pool is an area in main memory where ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
Test different settings with a representative workload to determine an optimal configuration. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool. The buffered ...