Re: MySQL Identifying worst-performing codes
| From: | Colin Guthrie | Date: | Thu, 08 Nov 2007 14:18:40 +0000 |
| Subject: | Re: MySQL Identifying worst-performing codes | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-44314@lists.php.net to get a copy of this message | ||
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/
HTH some people.
Col