mysql> select index_name,count(*) from information_schema.INNODB_BUFFER_PAGE where INDEX_NAME in('primary','gender') andTABLE_NAME like '%member%'group by index_name;
Emptyset (0.04 sec)
可以看到,重启后,没有访问过任何的数据页。
查询所有字段,再查看buffer pool的内容
1
2
3
4
5
6
7
mysql> select * from member where gender=1 limit 300000,1;
+--------+------------+--------+| id | name | gender |
+--------+------------+--------+1 row in set (0.38 sec)mysql> select index_name,count(*) from information_schema.INNODB_BUFFER_PAGE where INDEX_NAME in('primary','gender') andTABLE_NAME like '%member%'group by index_name;
mysql> select id from member where gender=1 limit 300000,1;
+--------+| id |
+--------+| 599465 |
+--------+1 row in set (0.08 sec)mysql> select index_name,count(*) from information_schema.INNODB_BUFFER_PAGE where INDEX_NAME in('primary','gender') andTABLE_NAME like '%member%'group by index_name;