[PHP] Re: MySQL Identifying worst-performing codes

[Colin Guthrie]

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

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

[PHP] Re: MySQL Identifying worst-performing codes

[Colin Guthrie]

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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php