up vote 1 down vote favorite
share [g+] share [fb]

Is there a way which I can have MySQL record its queries and their Explain so that I can figure out how to index the expensive stuff? I'm new to this stuff. Thank you.

link|improve this question
feedback

2 Answers

up vote 1 down vote

Try looking at maatkit. Particularly mk-query-digest. http://www.maatkit.org/doc/mk-query-digest.html

link|improve this answer
feedback
up vote 0 down vote

First use log-queries-not-using-indexes Then use explain on them to see possible indexes

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.