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] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
