Skip to content

Instantly share code, notes, and snippets.

@groman-me

groman-me/enable_optimizer

Created April 28, 2014 16:07
Show Gist options
  • Save groman-me/11376505 to your computer and use it in GitHub Desktop.
Save groman-me/11376505 to your computer and use it in GitHub Desktop.
Download ZIP
Enable optimizer trace in MySQL
Raw
enable_optimizer
mysql> SET optimizer_trace="enabled=on";
mysql> SELECT ....;
mysql> SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment