MySQL中通过trace分析优化器跟踪SQL

首先打开trace，设置格式为json

 

 

 

 

 

SELECT * FROM rental WHERE 1=1 AND rental_date >= '2005-05-25 04:00:00' AND rental_date <= '2006-05-06 05:00:00' AND inventory_id = 4466

 

 

 

 

select * FROM information_schema.`OPTIMIZER_TRACE`

 

设置trace 的最大可使用内存

SET optimizer_trace_max_mem_size = 1000000

 

https://segmentfault.com/a/1190000023427346、https://www.jianshu.com/p/e5c34c796bf6

https://www.cnblogs.com/zhang-qc/p/9410862.html、https://www.cnblogs.com/abclife/p/5534659.html

 

待续。。