MySQL Forums
Forum List  »  Performance

Re: Hints on what to check for bad performance
Posted by: Rick James
Date: October 02, 2015 09:59PM

First let's identify the likely query to dig deeper into:

long_query_time = 10
log_slow_slave_statements = ON
turn on the slowlog
wait until you catch the naughty query in the slowlog on both the old and new servers.

Then provide us the snippet from the slowlog, plus
SHOW CREATE TABLE
EXPLAIN SELECT ...

Possibly the EXPLAIN will show a difference, especially if they are running different versions.
Possibly something was different in the CREATE TABLE, such as the ENGINE.
Possibly the query and stats will give some other clues.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Hints on what to check for bad performance
725
October 02, 2015 09:59PM


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.