Books on query optimization? [closed]

As it currently stands, this question is not a good fit for开发者_如何学Python our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

Are there any books on query optimization, preferably for MySQL? I have High Performance MySQL but it doesn't seem to do a great job of giving you the knowledge necessary to optimize any query you might come across.

---

Try "High Performance MySQL" by Baron Schwartz et al, ISBN 978-0-596-10171-8. A lot of it is on server-side configuration settings and such, but Chapter 4 covers query diagnosis and optimization.

---

There's always the manual:

http://dev.mysql.com/doc/refman/5.0/en/optimization.html