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 databas
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
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:
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 queri
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 gen