详细说明在mysql查询时，offset过大影响性能的原因与优化方法

+--------+------------+--------+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; +------------+----------+(北联网教程,专业提供视频软件下载)

……