EXPLAIN Cheatsheet
Apr 22, 2008 / By Sheeri Cabral
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.
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.
Pingback: ???? ?????? » Blog Archive » MySQL EXPLAIN cheat sheet
Very nice!
I posted link to this page and PDF cheat sheet on my blog in Ukrainian.
Pingback: MySQL EXPLAIN Cheat Sheet | ???? ???-????????????
Pingback: Rodrigo Arce » Mejorar la performance de MySQL desde el código
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.
Pingback: Modificando el Performance en MySQL « Francisco Castán
Pingback: Modificando el Performance en MySQL | Francisco Castán