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]
