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!