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
待续。。