Hmm... mysqlsla is not bad However, I was hoping for something to help dive into the SQL queries and present their relation together in a single view of how the database and tables are being used.
mysqlsla shows the unique queries being used. And I'd like to see from the other end how the database and tables are being used by all queries together. For example, the report might show a visual representation of the database and table schema, and I can see what columns are getting hit most in all queries. If I see that a particular unindexed column is being hit a lot for searching, then I might choose to index it... for example. MySQL Proxy does not satisfy this need alone because I want to produce an analytical report based on database and table usage. Out of the box, using MySQL Proxy or turning on SQL logging serves the same function. I need to take the results from either and produce a report that analyzes usage. mysqlsla is a step in the right direction, but from my one day quick review of it, it does not appear to go deep enough. If I am not using mysqlsla to its full potential, I would appreciate a pointer on best practices. Thanks for the tool tips. I'll still be looking, so any other pointer from anyone would be great. -RG Baron Schwartz wrote: > 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]
