InnoDB INFORMATION_SCHEMA Buffer Pool Tables WHERE INDEX_NAME=’emp_no’ AND TABLE_NAME = ’‘employees‘.‘salaries‘’; +------------+-------+-----------------+ | INDEX_NAME | Pages | Total Data (MB) | +------------+-------+-----------------+ | emp_no | 1609 | 25 | +------------+-------+-----------------+ +------------+-------+-----------------+ | INDEX_NAME | Pages | Total Data (MB) | +------------+-------+-----------------+ | emp_no | 1608 | 25 | | PRIMARY | 6086 | 95 | +------------+-------+-----------------+ This query returns the number of pages and total data size of pages for all indexes defined on the employees.salaries  table: mysql>  SELECT INDEX_NAME, COUNT(*) AS Pages, ROUND(SUM(IF(COMPRESSED_SIZE = 0, @@GLOBAL.innodb_page_size, COMPRESSED_SIZE))/1024/1024) AS ’Total Data (MB)’ FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE WHERE TABLE_NAME = ’‘employees‘.‘salaries‘’ GROUP BY INDEX_NAME; The  INNODB_BUFFER_PAGE_LRU  table holds information about the pages in the  InnoDB  buffer pool, in particular how they are ordered that determines which pages to evict from the buffer pool when it becomes full. The definition for this page is the same as for  INNODB_BUFFER_PAGE , except this table has an LRU_POSITION  column instead of a  BLOCK_ID  column. This query counts the number of positions at a specific location in the LRU list occupied by pages of the employees.employees  table. Example 15.9 Querying LRU_POSITION Data in the INNODB_BUFFER_PAGE_LRU Table mysql>  SELECT COUNT(LRU_POSITION) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU WHERE TABLE_NAME=’‘employees‘.‘employees‘’ AND LRU_POSITION < 3072; +---------------------+ | COUNT(LRU_POSITION) | +---------------------+ | 548 | +---------------------+ mysql>  SELECT * FROM information_schema.INNODB_BUFFER_POOL_STATS \G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8192 FREE_BUFFERS: 1 DATABASE_PAGES: 8173 OLD_DATABASE_PAGES: 3014 MODIFIED_DATABASE_PAGES: 0 PENDING_DECOMPRESS: 0 PENDING_READS: 0 PENDING_FLUSH_LRU: 0 PENDING_FLUSH_LIST: 0 PAGES_MADE_YOUNG: 15907 PAGES_NOT_MADE_YOUNG: 3803101 PAGES_MADE_YOUNG_RATE: 0 PAGES_MADE_NOT_YOUNG_RATE: 0 NUMBER_PAGES_READ: 3270 NUMBER_PAGES_CREATED: 13176 NUMBER_PAGES_WRITTEN: 15109 PAGES_READ_RATE: 0 Example 15.10 Querying the INNODB_BUFFER_POOL_STATS Table The  INNODB_BUFFER_POOL_STATS  table provides information similar to  SHOW ENGINE INNODB STATUS  and  InnoDB  buffer pool status variables. 3319