调大trace的容量,防止被截断
set session optimizer_trace_max_mem_size = 10485760;
开启optimizer_trace
set session optimizer_trace="enabled=on";
执行SQL
select * from test03 where create_time > '2021-10-01 02:04:36';
SQL执行完成之后,查看TRACE
select TRACE from INFORMATION_SCHEMA.OPTIMIZER_TRACE\G
查看trace中具体的含义以后再介绍