I first read High Performance MySQL, 2nd edition about a year ago, when it first came out. I since re-read a few pages on occasion.
In my previous posts I've suggested ways to improve upon the common ranking solution. Very innovative stuff! Or... so I thought.
I happened to browse through the book today, and a section on User Variables caught my eye. "Let's see if I get get some insight", I thought to myself. Imagine my surprise when I realized almost everything I've suggested is discussed in this modest section, black on white, sitting on my bookshelf for over a year!
I have read it a year back, have forgotten all about it, have re-invented stuff already solved and discussed... Oh, for more brain capacity...
To be honest, this has happened to me more than once in the past few months; I'm taking the habit of browsing the web when I'm looking for answers to my problems; I forget that this book contains the answers to so many common, practical MySQL problems, and does so in a very direct and helpful manner.
So, yet again, thumbs up to High Performance MySQL. Really a must book. Get it if you haven't already!