INNODB_BUFFER_PAGE_LRU table holds
information about the pages in the
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
except this table has an
This table is primarily useful for expert-level performance monitoring, or when developing performance-related extensions for MySQL.
Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes time the number of active pages in the buffer pool. This allocation could potentially cause an out-of-memory error, especially for systems with multi-gigabyte buffer pools.
Querying this table requires MySQL to lock the data structure representing the buffer pool while traversing the LRU list, which can reduce concurrency, especially for systems with multi-gigabyte buffer pools.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices