19.30.14. The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
The INNODB_BUFFER_PAGE_LRU table holds
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 definition for this page is the same as for
INNODB_BUFFER_PAGE,
except this table has an LRU_POSITION column
instead of BLOCK_ID.
Notes:
This table is primarily useful for expert-level performance
monitoring, or when developing performance-related extensions
for MySQL.
Since the INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding InnoDB
system table for any new monitoring application you develop.
© 2012, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.