Re: MySQL Identifying worst-performing codes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

You can just turn on the MySQL option "log slow queries" and it logs
them for you. Make those more efficient and you've already taken care of
a lot of the low hanging fruit for db optimisation.

Col.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux