MySQL 分页查询优化技巧

select id,birthday,title from person order by title limit 400000,1

select id,birthday,title from person as p1 
join 
(select id from person order by title limit 400000,1) p2
on p1.id=p2.id;

CREATE TABLE `person` (
	`id` int NOT NULL AUTO_INCREMENT,
	`birthday` date DEFAULT NULL,
	`title` varchar(100) DEFAULT NULL,
	`comm1` varchar(6383) DEFAULT NULL,
	PRIMARY KEY (`id`) ,
	KEY `p_1`(`title`)
)ENGINE=InnODB AUTO_INCRENENT=438174 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;