Re: Hints on what to check for bad performance

[Peter Brawley]

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.