content_image/835875.jpg
• COMPRESSED_SIZE 

The compressed page size. NULL  for pages that are not compressed. 

• PAGE_STATE 

The page state. The following table shows the permitted values. 

<img src='content_image/835875.jpg'>

• IO_FIX 

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. 

• IS_OLD 

Whether the block is in the sublist of old blocks in the LRU list. 

• FREE_PAGE_CLOCK 

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. 

## Example 

• IS_STALE 

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 

