mysql大数据量分页查询优化

select * from table test limit 2500000,10;

优化方法

1. select * from test where id >= (select id from test limit 2500000,1) limit 10;
   
2. select * from test as a join (select id from test limit 2500000,10) as b on a.id=b.id;