By moving the sorting out of the database and back into the application, plus putting a limit on how many stories would be returned to any first request, Freund watched query execution time drop from an average 5.27 seconds down to 2.54 seconds. In other words, Clickability chopped 48% of the time it took to execute each query out of his overhead. The new tool "gave us a snapshot. We learned more about query usage in two minutes than we could gain in two years of ad hoc log analysis and guessing,"
Sounds like something mysqlsla (http://hackmysql.com/mysqlsla) is doing. I've been using mysqlsla with great success before but since it's freeware and the Enterprise Monitor is not, I think I'll be sticking to that.
I'm sure there are a lot more people upset by Sun's decision and will continue sticking to open source for query analysis.
Post a Comment