Paging optimization scheme for MySQL scale data table

Objective

Limit Paging Common scenario

select * from yundou_v3.bill_info limit 100,20;select * from yundou_v3.bill_info limit 400000,20;select * from yundou_v3.bill_info limit 600000,20;select * from yundou_v3.bill_info limit 800000,20;select * from yundou_v3.bill_info limit 1000000,20;

Volume-level data paging scheme

SELECT * FROM yundou_v3.bill_info WHERE id>= (    select id as id from yundou_v3.bill_info order by id asc limit 100,1) limit 20;SELECT * FROM yundou_v3.bill_info WHERE id>= (    select id as id from yundou_v3.bill_info order by id asc limit 400000,1) limit 20;SELECT * FROM yundou_v3.bill_info WHERE id>= (    select id as id from yundou_v3.bill_info order by id asc limit 600000,1) limit 20;SELECT * FROM yundou_v3.bill_info WHERE id>= (    select id as id from yundou_v3.bill_info order by id asc limit 800000,1) limit 20;SELECT * FROM yundou_v3.bill_info WHERE id>= (    select id as id from yundou_v3.bill_info order by id asc limit 1000000,1) limit 20;

Paging optimization scheme for MySQL scale data table