EXPLAIN Cheatsheet
Posted by Sheeri Cabral on Apr 22, 2008
At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive.
For those not at the conference, or those that want to make more, the file is downloadable as a 136Kb PDF at explain-diagram
* or tea, for those of us in the civilized world.
Category: Group Blog Posts, MySQL, Non-Tech Articles
Tags: cheatsheet, explain, guide, MySQL, optimization, optimize, performance, tuning, tutorial
Thanks for the cheatsheet. I appreciate it. I will have it at my desk to spill coffee on. Guess that means I am not civilized :)
Keith
Thanks, Sheeri. My laminated copy is attached safely at my desk. Bring some more of this goodness!
That was by far my favorite handout.
[...] ??????? ?????????? ??????????????? ???? ? [...]
Very nice!
I posted link to this page and PDF cheat sheet on my blog in Ukrainian.
[...] ????????? EXPLAIN Cheatsheet ???????? ??????????? ?????? ???????? ???????? ?????? [...]
[...] Bueno esto puede llevar mas investigación y trabajo, pero la clave es hacer que use índices (cuando pone index). Y que evite cosas pesadas como filesort. Les dejó un cheatsheet de EXPLAIN de la gente de Pythian. [...]
Thanks so much! It’s a shame this information isn’t readily available in the MySQL online documentation.
I found your cheat sheet on scribd but, since they don’t allow downloading without creating an account, I had to search for your original document to get here.
[...] Bueno esto puede llevar mas investigación y trabajo, pero la clave es hacer que use índices (cuando pone index). Y que evite cosas pesadas como filesort. Les dejó un cheatsheet de EXPLAIN de la gente de Pythian. [...]
[...] Bueno esto puede llevar mas investigación y trabajo, pero la clave es hacer que use índices (cuando pone index). Y que evite cosas pesadas como filesort. Les dejó un cheatsheet de EXPLAIN de la gente de Pythian. [...]