#打开设置
SET optimizer_trace='enabled=on';#最大内存根据实际情况而定, 可以不设置
SET OPTIMIZER_TRACE_MAX_MEM_SIZE=1000000;
SET END_MARKERS_IN_JSON=ON;
SET optimizer_trace_limit = 1;
SHOW VARIABLES LIKE '%optimizer_trace%';#执行sqlselect * from cc_ci where id='200000000140094'#执行所需sql后,查看该表信息即可看到详细的执行过程
SELECT * FROM `information_schema`.`OPTIMIZER_TRACE`;
mysql 优化索引 过程 explain profiling optimizer_trace(三)
首先拿到执行的sql语句,使用myslq自带的explain命令,使用explain 查看执行计划,explain select * from cc_ci where id = '200000000140094' 或 以json格式显示explain format=json select * from cc_ci where id = '200000000140094' { "query_block": { "select_id": 1, "cost_info.