diff options
Diffstat (limited to 'mysql-test/suite/innodb_i_s/innodb_buffer_page.result')
-rw-r--r-- | mysql-test/suite/innodb_i_s/innodb_buffer_page.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_i_s/innodb_buffer_page.result b/mysql-test/suite/innodb_i_s/innodb_buffer_page.result new file mode 100644 index 00000000000..6699fd9ae79 --- /dev/null +++ b/mysql-test/suite/innodb_i_s/innodb_buffer_page.result @@ -0,0 +1,24 @@ +SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_BUFFER_PAGE; +Table Create Table +INNODB_BUFFER_PAGE CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE` ( + `POOL_ID` int(11) unsigned NOT NULL DEFAULT 0, + `BLOCK_ID` 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, + `PAGE_STATE` enum('NOT_USED','READY_FOR_USE','FILE_PAGE','MEMORY','REMOVE_HASH') NOT NULL DEFAULT '', + `IO_FIX` enum('IO_NONE','IO_READ','IO_WRITE','IO_PIN') NOT NULL DEFAULT '', + `IS_OLD` int(1) NOT NULL DEFAULT 0, + `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT 0 +) ENGINE=MEMORY DEFAULT CHARSET=utf8 |