MySQL Forums
Forum List  »  Performance

Re: Problematic Query identification at the time of load on server
Posted by: René Olivo
Date: May 14, 2012 10:56AM

Hello,

I had a similar problem and my solution was very rustic, but it did the job:

Turn on both the mysql-query-log and mysql-slow-query-log

Identify each unique type of query you execute and pre-append EXPLAIN to each one of them.

Run them one by one on the production server and analyse the execution plan. If you see a USING TEMPORARY; USING FILESORT, then you may need to either:

Add an index that improves the performance of the query (careful, don't get too trigger happy and add too many indexes)

Or try executing the query in some other way.


After I did this for all queries the server load was more manageable

Options: ReplyQuote




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.