56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `text` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`old_id` int(10) unsigned NOT NULL,
`old_title` varchar(30) NOT NULL,
`old_text` mediumtext CHARACTER SET utf8mb4 NOT NULL,
`alias` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_title` (`old_title`(15))
) ENGINE=InnoDB AUTO_INCREMENT=787998 DEFAULT CHARSET=utf8
select * from text order by old_title;
innodb_buffer_pool_size
explain select * from text order by old_title
select * from text order by old_title limit 10000;