summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result')
-rw-r--r--mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result b/mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result
new file mode 100644
index 00000000000..00134233350
--- /dev/null
+++ b/mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result
@@ -0,0 +1,24 @@
+SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU;
+Table Create Table
+INNODB_BUFFER_PAGE_LRU 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
+) ENGINE=MEMORY DEFAULT CHARSET=utf8