I have not done much MySQL optimization before, but I have been diving into it deeper the last couple of days. Previously, I have read “High Performance MySQL” by OReilly, but I had not had a chance to put it into practice. Now I am working on my live management feedback web application to improve query performance and schema optimization. Interesting stuff!