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?

On 1/25/07, Sid Lane <jakes.dad@gmail.com> 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/...nalyzes-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.