Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
Information about generated invisible primary keys is visible by default in all INFORMATION_SCHEMA tables describing table columns, keys, or both, such as the COLUMNS and STATISTICS tables. INFORMATION_SCHEMA provides access to database metadata, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-thread-pool-table-reference.html
Table 28.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-group-stats-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_GROUP_STATS; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_group_stats; The TP_THREAD_GROUP_STATS table reports ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Because the statistics in the INNODB_CMP_PER_INDEX table are expensive to collect, you must enable the configuration option innodb_cmp_per_index_enabled before querying that table, and you might restrict such testing to a development server or a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
To avoid impacting performance on a production system, reproduce the issue you want to investigate and query buffer pool statistics on a test instance. The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples-compression-sect.html
Compressing or uncompressing pages has consumed less than a second since the time the statistics were reset, because the columns COMPRESS_TIME and UNCOMPRESS_TIME are zero. Example 17.1 Using the Compression Information Schema Tables The following ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
row *************************** TABLE_ID: 71 NAME: test/t1 STATS_INITIALIZED: Initialized NUM_ROWS: 1 CLUST_INDEX_SIZE: 1 OTHER_INDEX_SIZE: 0 MODIFIED_COUNTER: 1 AUTOINC: 0 REF_COUNT: 1 The STATS_INITIALIZED field indicates whether or not statistics ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema.html
InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. You can view a list ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...