content_image/778595.jpg content_image/778616.jpg
## Notes 

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

•This table is useful primarily for expert-level performance monitoring, or when developing performance- related extensions for MySQL. 

•You must have the PROCESS  privilege to query this table. 

•Use the INFORMATION_SCHEMA COLUMNS  table or the SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. 

•When tables, table rows, partitions, or indexes are deleted, associated pages remain in the buffer pool until space is required for other data. The INNODB_BUFFER_PAGE  table reports information about these pages until they are evicted from the buffer pool. For more information about how the InnoDB  manages buffer pool data, see Section 15.5.1, “Buffer Pool” . 

## 26.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table 

The INNODB_BUFFER_PAGE_LRU  table provides information about the pages in the InnoDB  buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. 

The INNODB_BUFFER_PAGE_LRU  table has the same columns as the INNODB_BUFFER_PAGE  table with a few exceptions. It has LRU_POSITION  and COMPRESSED  columns instead of BLOCK_ID  and PAGE_STATE columns, and it does not include and IS_STALE  column. 

For related usage information and examples, see Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables” . 

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

The INNODB_BUFFER_PAGE_LRU  table has these columns: 

• POOL_ID 

## Warning 

Querying the INNODB_BUFFER_PAGE_LRU  table can affect performance. Do not query this table on a production system unless you are aware of the performance impact and have determined it to be acceptable. 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 buffer pool ID. This is an identifier to distinguish between multiple buffer pool instances. 

• LRU_POSITION 

The position of the page in the LRU list. 

• SPACE 

The tablespace ID; the same value as INNODB_TABLES.SPACE . 

• PAGE_NUMBER 

