Debian Codegraph @

mysql-test/suite/innodb_i_s/innodb_buffer_page_lru.result

raw
1 SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU;
2 Table Create Table
3 INNODB_BUFFER_PAGE_LRU CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE_LRU` (
4 `POOL_ID` int(11) unsigned NOT NULL,
5 `LRU_POSITION` bigint(21) unsigned NOT NULL,
6 `SPACE` int(11) unsigned NOT NULL,
7 `PAGE_NUMBER` int(11) unsigned NOT NULL,
8 `PAGE_TYPE` varchar(64),
9 `FLUSH_TYPE` int(11) unsigned NOT NULL,
10 `FIX_COUNT` int(11) unsigned NOT NULL,
11 `IS_HASHED` int(1) NOT NULL,
12 `NEWEST_MODIFICATION` bigint(21) unsigned NOT NULL,
13 `OLDEST_MODIFICATION` bigint(21) unsigned NOT NULL,
14 `ACCESS_TIME` bigint(21) unsigned NOT NULL,
15 `TABLE_NAME` varchar(1024),
16 `INDEX_NAME` varchar(64),
17 `NUMBER_RECORDS` bigint(21) unsigned NOT NULL,
18 `DATA_SIZE` bigint(21) unsigned NOT NULL,
19 `COMPRESSED_SIZE` bigint(21) unsigned NOT NULL,
20 `COMPRESSED` int(1) NOT NULL,
21 `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE') NOT NULL,
22 `IS_OLD` int(1),
23 `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL
24 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
25 CREATE TEMPORARY TABLE t1 LIKE INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU;
26 DROP TEMPORARY TABLE t1;
27 CREATE TEMPORARY TABLE t1 AS SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU LIMIT 0;
28 DROP TEMPORARY TABLE t1;