Shulou(Shulou.com)05/31 Report--

This article mainly introduces the mysql query offset too much impact on the performance of what is the reason, has a certain reference value, interested friends can refer to, I hope you read this article after a lot of gains, the following let Xiaobian with everyone to understand.

Prepare test data sheets and data

1. create tables

CREATE TABLE `member` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL COMMENT 'lastname',`gender` tinyint(3) unsigned NOT NULL COMMENT ' gender', PRIMARY KEY (`id`), KEY `gender` (`gender`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. Insert 1000000 records

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.