diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-07-14 23:20:25 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-07-14 23:20:25 +0200 |
commit | 233655842374e0723d3191febac7ff2a11470fba (patch) | |
tree | b73835e5f12fdda18c63198d449c8d69f37adfb1 /mysql-test/suite/innodb/r/innodb_information_schema_buffer.result | |
parent | ff82741d0a5ef4e5dbd153b2d660a9fd3070c999 (diff) | |
download | mariadb-git-233655842374e0723d3191febac7ff2a11470fba.tar.gz |
many simple fixes for innodb suite,
merging tests from 5.6
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_information_schema_buffer.result')
-rw-r--r-- | mysql-test/suite/innodb/r/innodb_information_schema_buffer.result | 100 |
1 files changed, 8 insertions, 92 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_information_schema_buffer.result b/mysql-test/suite/innodb/r/innodb_information_schema_buffer.result index b4a350e77a3..dcdf3082067 100644 --- a/mysql-test/suite/innodb/r/innodb_information_schema_buffer.result +++ b/mysql-test/suite/innodb/r/innodb_information_schema_buffer.result @@ -6,28 +6,28 @@ CREATE TABLE infoschema_buffer_test (col1 INT) ENGINE = INNODB; INSERT INTO infoschema_buffer_test VALUES(9); SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE -WHERE TABLE_NAME like "%infoschema_buffer_test" +WHERE TABLE_NAME like "%infoschema_buffer_test%" and PAGE_STATE="file_page" and PAGE_TYPE="index"; TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE -test/infoschema_buffer_test GEN_CLUST_INDEX 1 29 FILE_PAGE INDEX +`test`.`infoschema_buffer_test` GEN_CLUST_INDEX 1 29 FILE_PAGE INDEX INSERT INTO infoschema_buffer_test VALUES(19); SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE -WHERE TABLE_NAME like "%infoschema_buffer_test" +WHERE TABLE_NAME like "%infoschema_buffer_test%" and PAGE_STATE="file_page" and PAGE_TYPE="index"; TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE -test/infoschema_buffer_test GEN_CLUST_INDEX 2 58 FILE_PAGE INDEX +`test`.`infoschema_buffer_test` GEN_CLUST_INDEX 2 58 FILE_PAGE INDEX CREATE INDEX idx ON infoschema_buffer_test(col1); SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE -WHERE TABLE_NAME like "%infoschema_buffer_test" +WHERE TABLE_NAME like "%infoschema_buffer_test%" and PAGE_STATE="file_page" and INDEX_NAME = "idx" and PAGE_TYPE="index"; TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE -test/infoschema_buffer_test idx 2 32 FILE_PAGE INDEX +`test`.`infoschema_buffer_test` idx 2 32 FILE_PAGE INDEX DROP TABLE infoschema_buffer_test; SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE -WHERE TABLE_NAME like "%infoschema_buffer_test"; +WHERE TABLE_NAME like "%infoschema_buffer_test%"; TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE CREATE TABLE infoschema_parent (id INT NOT NULL, PRIMARY KEY (id)) ENGINE=INNODB; @@ -38,93 +38,9 @@ ON DELETE CASCADE) ENGINE=INNODB; SELECT count(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE -WHERE TABLE_NAME like "%infoschema_child" and PAGE_STATE="file_page" +WHERE TABLE_NAME like "%infoschema_child%" and PAGE_STATE="file_page" and PAGE_TYPE="index"; count(*) 2 DROP TABLE infoschema_child; DROP TABLE infoschema_parent; -show create table information_schema.innodb_buffer_page; -Table Create Table -INNODB_BUFFER_PAGE CREATE TEMPORARY TABLE `INNODB_BUFFER_PAGE` ( - `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT '0', - `BLOCK_ID` bigint(21) unsigned NOT NULL DEFAULT '0', - `SPACE` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGE_TYPE` varchar(64) DEFAULT NULL, - `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT '0', - `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT '0', - `IS_HASHED` varchar(3) DEFAULT NULL, - `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(1024) 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` varchar(64) DEFAULT NULL, - `IO_FIX` varchar(64) DEFAULT NULL, - `IS_OLD` varchar(3) DEFAULT NULL, - `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT '0' -) ENGINE=MEMORY DEFAULT CHARSET=utf8 -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` bigint(21) unsigned NOT NULL DEFAULT '0', - `LRU_POSITION` bigint(21) unsigned NOT NULL DEFAULT '0', - `SPACE` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGE_NUMBER` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGE_TYPE` varchar(64) DEFAULT NULL, - `FLUSH_TYPE` bigint(21) unsigned NOT NULL DEFAULT '0', - `FIX_COUNT` bigint(21) unsigned NOT NULL DEFAULT '0', - `IS_HASHED` varchar(3) DEFAULT NULL, - `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(1024) 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` varchar(3) DEFAULT NULL, - `IO_FIX` varchar(64) DEFAULT NULL, - `IS_OLD` varchar(3) DEFAULT NULL, - `FREE_PAGE_CLOCK` bigint(21) unsigned NOT NULL DEFAULT '0' -) ENGINE=MEMORY DEFAULT CHARSET=utf8 -show create table information_schema.innodb_buffer_pool_stats; -Table Create Table -INNODB_BUFFER_POOL_STATS CREATE TEMPORARY TABLE `INNODB_BUFFER_POOL_STATS` ( - `POOL_ID` bigint(21) unsigned NOT NULL DEFAULT '0', - `POOL_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0', - `FREE_BUFFERS` bigint(21) unsigned NOT NULL DEFAULT '0', - `DATABASE_PAGES` bigint(21) unsigned NOT NULL DEFAULT '0', - `OLD_DATABASE_PAGES` bigint(21) unsigned NOT NULL DEFAULT '0', - `MODIFIED_DATABASE_PAGES` bigint(21) unsigned NOT NULL DEFAULT '0', - `PENDING_DECOMPRESS` bigint(21) unsigned NOT NULL DEFAULT '0', - `PENDING_READS` bigint(21) unsigned NOT NULL DEFAULT '0', - `PENDING_FLUSH_LRU` bigint(21) unsigned NOT NULL DEFAULT '0', - `PENDING_FLUSH_LIST` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGES_MADE_YOUNG` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGES_NOT_MADE_YOUNG` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGES_MADE_YOUNG_RATE` double NOT NULL DEFAULT '0', - `PAGES_MADE_NOT_YOUNG_RATE` double NOT NULL DEFAULT '0', - `NUMBER_PAGES_READ` bigint(21) unsigned NOT NULL DEFAULT '0', - `NUMBER_PAGES_CREATED` bigint(21) unsigned NOT NULL DEFAULT '0', - `NUMBER_PAGES_WRITTEN` bigint(21) unsigned NOT NULL DEFAULT '0', - `PAGES_READ_RATE` double NOT NULL DEFAULT '0', - `PAGES_CREATE_RATE` double NOT NULL DEFAULT '0', - `PAGES_WRITTEN_RATE` double NOT NULL DEFAULT '0', - `NUMBER_PAGES_GET` bigint(21) unsigned NOT NULL DEFAULT '0', - `HIT_RATE` bigint(21) unsigned NOT NULL DEFAULT '0', - `YOUNG_MAKE_PER_THOUSAND_GETS` bigint(21) unsigned NOT NULL DEFAULT '0', - `NOT_YOUNG_MAKE_PER_THOUSAND_GETS` bigint(21) unsigned NOT NULL DEFAULT '0', - `NUMBER_PAGES_READ_AHEAD` bigint(21) unsigned NOT NULL DEFAULT '0', - `NUMBER_READ_AHEAD_EVICTED` bigint(21) unsigned NOT NULL DEFAULT '0', - `READ_AHEAD_RATE` double NOT NULL DEFAULT '0', - `READ_AHEAD_EVICTED_RATE` double NOT NULL DEFAULT '0', - `LRU_IO_TOTAL` bigint(21) unsigned NOT NULL DEFAULT '0', - `LRU_IO_CURRENT` bigint(21) unsigned NOT NULL DEFAULT '0', - `UNCOMPRESS_TOTAL` bigint(21) unsigned NOT NULL DEFAULT '0', - `UNCOMPRESS_CURRENT` bigint(21) unsigned NOT NULL DEFAULT '0' -) ENGINE=MEMORY DEFAULT CHARSET=utf8 |