Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-engines-table.html
This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these columns: ENGINE The name of the storage engine. SUPPORT The server's level of support for the storage ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. COMPRESS_OPS The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. PAGES_USED The ...