On 1/25/07, Sid Lane <[EMAIL PROTECTED]> wrote:
all, I have been tasked with upgrading a critical 3.23.55 database to 5.0 (.27-ish). short version is it's never been upgraded because authors have moved on and nobody's sure of everything that uses it. I enabled the general log a few days ago and have a good body of data with which to go code hunting but (being a DBA) would like to load this into a couple of tables for easier analysis. has anyone already invented this wheel or should I post my solution if I end up doing it myself?
This project may be of some help: http://sourceforge.net/projects/myprofi If not, at least it would give you a starting point. There are many tools to parse the slow query log, if the above isn't helpful, maybe you can modify one of them. http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://www.willamowius.de/mysql-tools.html -- -jp They say that lightning never strikes the same place twice. Niether does Chuck Norris. He doesn't have to.
