optimizer trace
2023-06-13 本文已影响0人
耗子_aca3
使用步骤：
SHOW VARIABLES LIKE "optimizer_trace";
# SET OPTIMIZER_TRACE="enabled=on",END_MARKERS_IN_JSON=on;
SET OPTIMIZER_TRACE="enabled=on";
SET optimizer_trace_offset=-30, optimizer_trace_limit=30;
select * from ai_chat.wechat_users order by openid limit 100;
SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
SET optimizer_trace="enabled=off";
