MySQL Forums
Forum List  »  Newbie

optimizing slow queries
Posted by: Shantanu Oak
Date: March 19, 2008 05:08AM

I have set long query time to 2 seconds in my cnf file. Therefore all the queries taking more than 2 seconds are logged in the file called mysql-slow.log and the file size is 20 Mb.
Is there anyway to sort this file and find out the queries those are taking the most time so that I can optimize only those ones?

Options: ReplyQuote


Subject
Written By
Posted
optimizing slow queries
March 19, 2008 05:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.