Are you aware of an existing DBA opening or consulting requirement in your organization? Enter your email for a chance to win one year's access to Safari Books.
EXPLAIN Cheatsheet
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.pdf
* or tea, for those of us in the civilized world.
Apr 22, 2008
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. [...]