Debian Codegraph @

mysql-test/suite/innodb_i_s/innodb_buffer_page.result

raw
1 SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_BUFFER_PAGE;
2 Table Create Table
3 INNODB_BUFFER_PAGE CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE` (
4 `POOL_ID` int(11) unsigned NOT NULL,
5 `BLOCK_ID` 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 `PAGE_STATE` enum('NOT_USED','MEMORY','REMOVE_HASH','FILE_PAGE') NOT NULL,
21 `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE') NOT NULL,
22 `IS_OLD` int(1) NOT NULL,
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;
26 DROP TEMPORARY TABLE t1;
27 CREATE TEMPORARY TABLE t1 AS SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE LIMIT 0;
28 DROP TEMPORARY TABLE t1;