Ask YC: Can you recommend me a good MySQL optimization book?

1 pointROFISH3 comments

I have seen a lot of blog posts, presentations, etc. about the "bad" way of optimization, but there isn't much in terms of a good way. I'm really looking for a good book, not just a couple of blog posts. A resource on the proper way of doing things since I'm starting to hit a wall figuring it out myself vs. the knowledge of an expert.

View on HN

My favorite advanced MySQL book is the O'Reilly one by Jeremy Zawodny (formerly the chief MySQL dude at Yahoo, now of Craigslist):

http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...

You can learn the basics of MySQL online or through just about any book, but once you've gotten beyond that and want to learn more, this book is loads better than all the others.

Thanks, I'll look into it.

not specifically mysql, but 'the art of sql' is pretty good for database optimization and performance

Reply on news.ycombinator.com