search

zqhong / pelican-blog

Use Pelican generate static blog site
1 stars 0 forks source link

MySQL 5.6 - Tracing the Optimizer #7

Open zqhong opened 7 years ago

zqhong commented 7 years ago

经典用法（session 级别）

# Turn tracing on (it's off by default):
SET optimizer_trace="enabled=on";
SELECT ...; # your query here
SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
# possibly more queries...
# When done with tracing, disable it:
SET optimizer_trace="enabled=off";

扩展阅读

[MySQL 5.6] 初识5.6的optimizer trace