Movatterモバイル変換

TheINNODB_CACHED_INDEXES table reports the number of index pages cached in theInnoDB buffer pool for each index.

For related usage information and examples, seeSection 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”.

TheINNODB_CACHED_INDEXES table has these columns:

Examples

This query returns the number of index pages cached in theInnoDB buffer pool for a specific index:

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_CACHED_INDEXES WHERE INDEX_ID=65\G*************************** 1. row ***************************      SPACE_ID: 4294967294      INDEX_ID: 65N_CACHED_PAGES: 45

This query returns the number of index pages cached in theInnoDB buffer pool for each index, using theINNODB_INDEXES andINNODB_TABLES tables to resolve the table name and index name for eachINDEX_ID value.

SELECT  tables.NAME AS table_name,  indexes.NAME AS index_name,  cached.N_CACHED_PAGES AS n_cached_pagesFROM  INFORMATION_SCHEMA.INNODB_CACHED_INDEXES AS cached,  INFORMATION_SCHEMA.INNODB_INDEXES AS indexes,  INFORMATION_SCHEMA.INNODB_TABLES AS tablesWHERE  cached.INDEX_ID = indexes.INDEX_ID  AND indexes.TABLE_ID = tables.TABLE_ID;

Notes