INNODB_BUFFER_PAGE_LRU

This page is part of MariaDB's Documentation.

The parent of this page is: Information Schema for MariaDB Enterprise Server

Topics on this page:

Overview
USAGE
DETAILS
- SYNONYMS
- SCHEMA
- PARAMETERS
- SKYSQL
- PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
RELATED TOPICS
EXTERNAL REFERENCES

Overview

InnoDB Buffer Page in LRU

USAGE

DETAILS

SYNONYMS

SCHEMA

CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` (
  `POOL_ID` int(11) unsigned NOT NULL,
  `LRU_POSITION` bigint(21) unsigned NOT NULL,
  `SPACE` int(11) unsigned NOT NULL,
  `PAGE_NUMBER` int(11) unsigned NOT NULL,
  `PAGE_TYPE` varchar(64),
  `FLUSH_TYPE` int(11) unsigned NOT NULL,
  `FIX_COUNT` int(11) unsigned NOT NULL,
  `IS_HASHED` int(1) NOT NULL,
  `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL,
  `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL,
  `ACCESS_TIME` bigint(21) unsigned NOT NULL,
  `TABLE_NAME` varchar(1024),
  `INDEX_NAME` varchar(64),
  `NUMBER_RECORDS` bigint(21) unsigned NOT NULL,
  `DATA_SIZE` bigint(21) unsigned NOT NULL,
  `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL,
  `COMPRESSED` int(1) NOT NULL,
  `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE') NOT NULL,
  `IS_OLD` int(1),
  `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL
)

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1. Schema changed in MariaDB Enterprise Server 10.6.7-3: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(64) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.6 Community	Present starting in MariaDB Community Server 10.6.0. Schema changed in MariaDB Community Server 10.6.6: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(64) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.5 Enterprise	Schema changed in MariaDB Enterprise Server 10.5.3-1: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULLint(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(10264) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3)int(1) NOT NULL DEFAULT NULL0, `IO_FIX` varchar(64) DEFAULenum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` varchar(3int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Enterprise Server 10.5.4-2: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(64) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Enterprise Server 10.5.15-10: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(64) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.5 Community	Schema changed in MariaDB Community Server 10.5.0: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3)int(1) NOT NULL DEFAULT NULL0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(10264) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3) DEFAULT NULL, `IO_FIX` varchar(64) DEFAULT NULLint(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL DEFAULT '', `IS_OLD` varchar(3int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Community Server 10.5.1: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(64) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL DEFAULT '', `IS_OLD` int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Community Server 10.5.4: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(64) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Community Server 10.5.14: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(64) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1. Schema changed in MariaDB Enterprise Server 10.4.24-15: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULL,), `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(1024) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3) DEFAULT NULL,), `IO_FIX` varchar(64) DEFAULT NULL,), `IS_OLD` varchar(3) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.4 Community	Present starting in MariaDB Community Server 10.4.0. Schema changed in MariaDB Community Server 10.4.23: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULL,), `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(1024) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3) DEFAULT NULL,), `IO_FIX` varchar(64) DEFAULT NULL,), `IS_OLD` varchar(3) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.3 Enterprise	Present starting in MariaDB Enterprise Server 10.3.16-1. Schema changed in MariaDB Enterprise Server 10.3.34-15: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULL,), `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(1024) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3) DEFAULT NULL,), `IO_FIX` varchar(64) DEFAULT NULL,), `IS_OLD` varchar(3) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.3 Community	Present starting in MariaDB Community Server 10.3.0. Schema changed in MariaDB Community Server 10.3.33: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULL,), `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(1024) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3) DEFAULT NULL,), `IO_FIX` varchar(64) DEFAULT NULL,), `IS_OLD` varchar(3) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.2 Enterprise	Present starting in MariaDB Enterprise Server 10.2.25-1.
10.2 Community	Present starting in MariaDB Community Server 10.2.0. Schema changed in MariaDB Community Server 10.2.2: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT '0'0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT '0'0, `SPACE` bigint(21) unsigned NOT NULL DEFAULT '0'0, `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT '0'0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT '0'0, `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT '0'0, `IS_HASHED` varchar(3) DEFAULT NULL, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT '0'0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT '0'0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT '0'0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(1024) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT '0'0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0'0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0'0, `COMPRESSED` varchar(3) DEFAULT NULL, `IO_FIX` varchar(64) DEFAULT NULL, `IS_OLD` varchar(3) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT '0'0 )

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1. Schema changed in MariaDB Enterprise Server 10.6.7-3: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(64) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.5 Enterprise	Schema changed in MariaDB Enterprise Server 10.5.3-1: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULLint(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(10264) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3)int(1) NOT NULL DEFAULT NULL0, `IO_FIX` varchar(64) DEFAULenum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` varchar(3int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Enterprise Server 10.5.4-2: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL, `FLUSH_TYPE` bigint(2int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL, `INDEX_NAME` varchar(64) DEFAULT NULL, `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL, `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 ) Schema changed in MariaDB Enterprise Server 10.5.15-10: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` int(11) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` int(11) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` int(11) unsigned NOT NULL DEFAULT 0, `IS_HASHED` int(1) NOT NULL DEFAULT 0, `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(64) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` int(1) NOT NULL DEFAULT 0, `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL, `IS_OLD` int(1) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1. Schema changed in MariaDB Enterprise Server 10.4.24-15: ... CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` ( `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT 0, `SPACE` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT 0, `PAGE_TYPE` varchar(64) DEFAULT NULL,), `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT 0, `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT 0, `IS_HASHED` varchar(3) DEFAULT NULL,), `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL DEFAULT 0, `ACCESS_TIME` bigint(21) unsigned NOT NULL DEFAULT 0, `TABLE_NAME` varchar(1024) DEFAULT NULL,), `INDEX_NAME` varchar(1024) DEFAULT NULL,), `NUMBER_RECORDS` bigint(21) unsigned NOT NULL DEFAULT 0, `DATA_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0, `COMPRESSED` varchar(3) DEFAULT NULL,), `IO_FIX` varchar(64) DEFAULT NULL,), `IS_OLD` varchar(3) DEFAULT NULL,), `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 )

EXTERNAL REFERENCES

Additional information on this topic may be found in the MariaDB Public Knowledge Base.

INNODB_BUFFER_PAGE_LRU

Overview

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

RELATED TOPICS

EXTERNAL REFERENCES