[摘要]+--------+1 row in set (0.08 sec)mysql> select index_name,count(*) from information_schema.INNOD...
+--------+1 row in set (0.08 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过大影响性能的原因与优化办法