Re: Re: MySQL Identifying worst-performing codes
| From: | chris smith | Date: | Thu, 08 Nov 2007 22:24:19 +0000 |
| Subject: | Re: Re: MySQL Identifying worst-performing codes | ||
| References: | 1 2 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-44322@lists.php.net to get a copy of this message | ||
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.
--
Postgresql & php tutorials
http://www.designmagick.com/