[摘要]+--------+------------+--------+1 row in set (0.38 sec)mysql> select index_name,count(*) from in...
+--------+------------+--------+1 row in set (0.38 sec)mysql> select index_name,count(*) from information_schema.INNODB_BUFFER_PAGE where INDEX_NAME in('primary','gender') and TABLE_NAME like '%member%' group by index_name;
+------------+----------+ |
关键词： 详细说明在mysql查询时 offset过大影响性能的原因与优化办法