| 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; |