| 1 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS; |
| 2 |
POOL_ID POOL_SIZE FREE_BUFFERS DATABASE_PAGES OLD_DATABASE_PAGES MODIFIED_DATABASE_PAGES PENDING_DECOMPRESS PENDING_READS PENDING_FLUSH_LRU PENDING_FLUSH_LIST PAGES_MADE_YOUNG PAGES_NOT_MADE_YOUNG PAGES_MADE_YOUNG_RATE PAGES_MADE_NOT_YOUNG_RATE NUMBER_PAGES_READ NUMBER_PAGES_CREATED NUMBER_PAGES_WRITTEN PAGES_READ_RATE PAGES_CREATE_RATE PAGES_WRITTEN_RATE NUMBER_PAGES_GET HIT_RATE YOUNG_MAKE_PER_THOUSAND_GETS NOT_YOUNG_MAKE_PER_THOUSAND_GETS NUMBER_PAGES_READ_AHEAD NUMBER_READ_AHEAD_EVICTED READ_AHEAD_RATE READ_AHEAD_EVICTED_RATE LRU_IO_TOTAL LRU_IO_CURRENT UNCOMPRESS_TOTAL UNCOMPRESS_CURRENT |
| 3 |
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # |
| 4 |
CREATE TABLE infoschema_buffer_test (col1 INT) ENGINE = INNODB; |
| 5 |
INSERT INTO infoschema_buffer_test VALUES(9); |
| 6 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE |
| 7 |
WHERE TABLE_NAME LIKE '%infoschema_buffer_test%' AND PAGE_TYPE='index'; |
| 8 |
POOL_ID BLOCK_ID SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK |
| 9 |
0 # # 3 INDEX 0 FIX AHI LSN LSN TIME `test`.`infoschema_buffer_test` GEN_CLUST_INDEX 1 29 0 FILE_PAGE IO_FIX OLD # |
| 10 |
INSERT INTO infoschema_buffer_test VALUES(19); |
| 11 |
CREATE INDEX idx ON infoschema_buffer_test(col1); |
| 12 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE |
| 13 |
WHERE TABLE_NAME LIKE '%infoschema_buffer_test%' AND PAGE_TYPE='index'; |
| 14 |
POOL_ID BLOCK_ID SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK |
| 15 |
0 # # 3 INDEX 0 FIX AHI LSN LSN TIME `test`.`infoschema_buffer_test` GEN_CLUST_INDEX 2 58 0 FILE_PAGE IO_FIX OLD # |
| 16 |
0 # # 4 INDEX 0 FIX AHI LSN LSN TIME `test`.`infoschema_buffer_test` idx 2 32 0 FILE_PAGE IO_FIX OLD # |
| 17 |
DROP TABLE infoschema_buffer_test; |
| 18 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE |
| 19 |
WHERE TABLE_NAME LIKE '%infoschema_buffer_test%'; |
| 20 |
POOL_ID BLOCK_ID SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK |
| 21 |
CREATE TABLE infoschema_parent (id INT NOT NULL, PRIMARY KEY (id)) |
| 22 |
ENGINE=INNODB; |
| 23 |
CREATE TABLE infoschema_child (id INT, parent_id INT, INDEX par_ind (parent_id), |
| 24 |
FOREIGN KEY (parent_id) |
| 25 |
REFERENCES infoschema_parent(id) |
| 26 |
ON DELETE CASCADE) |
| 27 |
ENGINE=INNODB; |
| 28 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE |
| 29 |
WHERE TABLE_NAME LIKE '%infoschema_child%'; |
| 30 |
POOL_ID BLOCK_ID SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK |
| 31 |
0 # # 3 INDEX 0 FIX AHI LSN LSN TIME `test`.`infoschema_child` GEN_CLUST_INDEX 0 0 0 FILE_PAGE IO_FIX OLD # |
| 32 |
0 # # 4 INDEX 0 FIX AHI LSN LSN TIME `test`.`infoschema_child` par_ind 0 0 0 FILE_PAGE IO_FIX OLD # |
| 33 |
DROP TABLE infoschema_child; |
| 34 |
DROP TABLE infoschema_parent; |