EXPLAIN Cheatsheet

Posted in: Technical Track

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.

Interested in working with Sheeri? Schedule a tech call.

9 Comments. Leave new

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

Reply
Artem Russakovskii
April 22, 2008 5:06 pm

Thanks, Sheeri. My laminated copy is attached safely at my desk. Bring some more of this goodness!

Reply
Mark Callaghan
April 22, 2008 8:23 pm

That was by far my favorite handout.

Reply

Very nice!
I posted link to this page and PDF cheat sheet on my blog in Ukrainian.

Reply
MySQL EXPLAIN Cheat Sheet | ???? ???-????????????
June 6, 2009 6:19 pm

[…] ????????? EXPLAIN Cheatsheet ???????? ??????????? ?????? ???????? ???????? ?????? […]

Reply
Rodrigo Arce » Mejorar la performance de MySQL desde el código
June 29, 2009 3:40 pm

[…] 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. […]

Reply

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.

Reply
Modificando el Performance en MySQL « Francisco Castán
January 12, 2011 9:04 pm

[…] 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. […]

Reply
Modificando el Performance en MySQL | Francisco Castán
June 14, 2011 1:52 pm

[…] 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. […]

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *