MySQL Forums
Forum List  »  Performance

Re: Hints on what to check for bad performance
Posted by: Peter Brawley
Date: September 21, 2015 10:01PM

2-, 5- and 10-min query times merit investigation---it's highly likely they can be improved by tweaking MySQL settings, and/or switching tables to InnoDB, and/or adding or tweaking covering indexes and otherwise and optimising the slow queries.

For starters, review your system & mysql settings against the pointers & suggestions at http://mysql.rjweb.org/doc.php/memory

For a first look at what settings might need attention, run one or more of the tests described under "Optimisation cheatsheet" at http://www.artfulsoftware.com/infotree/mysqltips.php.

For specific queries, post the query, the result of running Explain Extended on the query, and results of Show Create Table for each non-trivial table referenced in the query.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Hints on what to check for bad performance
756
September 21, 2015 10:01PM


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.