The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table • PAGE_STATE • COMPRESSED_SIZE The compressed page size.  NULL  for pages that are not compressed. The page state. The following table shows the permitted values. Table 26.5 INNODB_BUFFER_PAGE.PAGE_STATE Values Page State Description FILE_PAGE A buffered file page MEMORY Contains a main memory object NOT_USED In the free list NULL Clean compressed pages, compressed pages in the flush list, pages used as buffer pool watch sentinels READY_FOR_USE A free page REMOVE_HASH Hash index should be removed before placing in the free list • FREE_PAGE_CLOCK • IS_OLD • IO_FIX • IS_STALE Whether any I/O is pending for this page:  IO_NONE  = no pending I/O,  IO_READ  = read pending, IO_WRITE  = write pending,  IO_PIN  = relocation and removal from the flush not permitted. Whether the block is in the sublist of old blocks in the LRU list. The value of the  freed_page_clock  counter when the block was the last placed at the head of the LRU list. The  freed_page_clock  counter tracks the number of blocks removed from the end of the LRU list. Whether the page is stale. Added in MySQL 8.0.24. mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE LIMIT 1\G *************************** 1. row *************************** POOL_ID: 0 BLOCK_ID: 0 SPACE: 97 PAGE_NUMBER: 2473 PAGE_TYPE: INDEX FLUSH_TYPE: 1 FIX_COUNT: 0 IS_HASHED: YES NEWEST_MODIFICATION: 733855581 OLDEST_MODIFICATION: 0 ACCESS_TIME: 3378385672 TABLE_NAME: ‘employees‘.‘salaries‘ INDEX_NAME: PRIMARY NUMBER_RECORDS: 468 Example 4844