|Buffer Pool ID. An identifier to distinguish between multiple buffer pool instances.|
|Buffer Pool Block ID.|
|Tablespace ID. Uses the same value as in
|Page type string. One of |
|Number of threads using this block within the buffer pool. When zero, the block is eligible to be evicted.|
|Whether hash index has been built on this page.|
|Log Sequence Number of the youngest modification.|
|Log Sequence Number of the oldest modification.|
|Time of first access.|
|Name of the table the page belongs to.|
|Name of the index the page belongs to. It can be the name of a clustered index or a secondary index.|
|Number of records within the page.|
|Sum of the sizes of the records.|
|Compressed page size. Null for pages that are not compressed.|
|Page state. A page with valid data has one of the following states:
|Specifies whether any I/O is pending for this page:
This table is primarily useful for expert-level performance monitoring, or when developing performance-related extensions for MySQL.
INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding
system table for any new monitoring application you develop.
You must have the
PROCESS privilege to
query this table.