Re: Re: MySQL Identifying worst-performing codes

There may be something useful here... http://forge.mysql.com/ chris smith wrote: > On Nov 9, 2007 1:18 AM, Colin Guthrie <gmane@colin.guthr.ie> wrote: > >> Lasitha Alawatta wrote: >> >>> There is a tool call "idera" (SQL diagnostic manager). Basically it is >>> a performance monitoring and diagnostics tool. >>> >>> It has a feature; >>> Identifying of worst-performing codes – >>> >>> Identifies performance bottlenecks such as the worst-performing stored >>> procedures, long-running queries, most frequently run queries, SQL >>> Statements and SQL batches >>> >>> http://www.idera.com/Products/SQLdm/Features.aspx >>> >>> >>> I'm looking for a same like tool for MySQL. Is anyone have any ideas. >>> >> I know this is OT for this list but..... >> >> In addition to the slow query logging I mentioned before (which you >> seemed to appreciate :)), I've just stumbled across this: >> http://rackerhacker.com/mysqltuner/ >> > > http://jeremy.zawodny.com/mysql/mytop/ might come in handy too. > >