You could also try http://hackmysql.com/mysqlsla
On Dec 6, 2007 9:23 AM, B. Keith Murphy <[EMAIL PROTECTED]> wrote: > MySQL Proxy is good. It doesn't fit in some environments however. > Another option would be the QPP (Query Processing Programs) that I and a > co-worker have developed. They can be downloaded at > http://www.paragon-cs.com/queryprogs. > > thanks > > Keith > > Michael Dykman wrote: > > Have you considered: > > > > http://forge.mysql.com/wiki/MySQL_Proxy > > > > > > > > On Dec 5, 2007 5:14 PM, Russell E Glaue <[EMAIL PROTECTED]> wrote: > > > >> Does anyone know of an open source SQL analysis tool? > >> > >> I have query logging turned on in MySQL. > >> And I would like to analyze all the logged SQL select queries to find out > >> how > >> the database is being used, and then optimize MySQL databases or the SQL > >> views/statements accordingly. > >> > >> Perhaps it would generate a report of most used columns for searching and > >> retrieving, across all logged SQL queries. > >> > >> > >> We have a software package used to generate reports from data in MySQL, > >> and the > >> users are allowed to make ad hoc querying. So we do not (necessarily) have > >> control over the SQL queries that are executed. > >> And once in a great while, some unknowing user will execute a query > >> (unoptimized > >> of course) that takes longer than satisfactory to execute. > >> > >> So I want to analyze all the queries users have issued, and try and > >> optimize the > >> database tables accordingly, or adjust the views in the reporting software. > >> > >> > >> Any tools (open source only) out there to help? > >> > >> > >> -RG > >> > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > >> > > > > > > > > > > > -- > B. Keith Murphy > > Paragon Consulting Services > http://www.paragon-cs.com > 850-637-3877 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
