2022-11-22 mysql-filesort-执行分析

摘要:

mysql-filesort-分析

参考:

https://opensource.actionsky.com/20200402-mysql/

DDL:

表结构：

 
CREATE TABLE `tests1` (
  `a1` varchar(300) DEFAULT NULL,
  `a2` varchar(300) DEFAULT NULL,
  `a3` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

插入数据:

insert into tests1 values( "a", "a", "a");
insert into tests1 values( "a", "b", "b");
insert into tests1 values( "a", "c", "c");
insert into tests1 values( "b", "d", "d");
insert into tests1 values( "b", "e", "e");
insert into tests1 values( "b"