1SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS; 2SELECT count(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS; 3SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE; 4SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE; 5CREATE TABLE infoschema_buffer_test (col1 INT) ENGINE = INNODB; 6INSERT INTO infoschema_buffer_test VALUES(9); 7SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE 8FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE 9WHERE TABLE_NAME like "%infoschema_buffer_test%" 10 and PAGE_STATE="file_page" and PAGE_TYPE="index"; 11TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE 12`test`.`infoschema_buffer_test` GEN_CLUST_INDEX 1 29 FILE_PAGE INDEX 13INSERT INTO infoschema_buffer_test VALUES(19); 14SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE 15FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE 16WHERE TABLE_NAME like "%infoschema_buffer_test%" 17and PAGE_STATE="file_page" and PAGE_TYPE="index"; 18TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE 19`test`.`infoschema_buffer_test` GEN_CLUST_INDEX 2 58 FILE_PAGE INDEX 20CREATE INDEX idx ON infoschema_buffer_test(col1); 21SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE 22FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE 23WHERE TABLE_NAME like "%infoschema_buffer_test%" 24and PAGE_STATE="file_page" and INDEX_NAME = "idx" and PAGE_TYPE="index"; 25TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE 26`test`.`infoschema_buffer_test` idx 2 32 FILE_PAGE INDEX 27`test`.`infoschema_buffer_test` idx 2 32 FILE_PAGE INDEX 28DROP TABLE infoschema_buffer_test; 29SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE 30FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE 31WHERE TABLE_NAME like "%infoschema_buffer_test%"; 32TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE PAGE_STATE PAGE_TYPE 33CREATE TABLE infoschema_parent (id INT NOT NULL, PRIMARY KEY (id)) 34ENGINE=INNODB; 35CREATE TABLE infoschema_child (id INT, parent_id INT, INDEX par_ind (parent_id), 36FOREIGN KEY (parent_id) 37REFERENCES infoschema_parent(id) 38ON DELETE CASCADE) 39ENGINE=INNODB; 40SELECT count(*) 41FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE 42WHERE TABLE_NAME like "%infoschema_child%" and PAGE_STATE="file_page" 43and PAGE_TYPE="index"; 44count(*) 452 46DROP TABLE infoschema_child; 47DROP TABLE infoschema_parent; 48