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.
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.
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.