[PHP] RE: [PHP-DB] Re: MySQL Identifying worst-performing codes
Dear Col, I'm highly appreciate your reply. Best Regards, Lasitha -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Colin Guthrie Sent: Thursday, October 04, 2007 7:47 PM To: [EMAIL PROTECTED] Cc: php-general@lists.php.net; [EMAIL PROTECTED] Subject: [PHP-DB] Re: MySQL Identifying worst-performing codes 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 DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take any action in reliance of this transmission and you should notify us as soon as possible. If you have received it in error, please contact the message sender immediately. This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and DOTW accepts no liability in connection therewith. This e-mail and all other electronic (including voice) communications from the sender's company are for informational purposes only. No such communication is intended by the sender to constitute either an electronic record or an electronic signature or to constitute any agreement by the sender to conduct a transaction by electronic means.
[PHP] Re: [PHP-DB] Re: MySQL Identifying worst-performing codes
On Nov 9, 2007 1:18 AM, Colin Guthrie <[EMAIL PROTECTED]> 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/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: [PHP-DB] 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 <[EMAIL PROTECTED]> 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. > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php