Re: Hints on what to check for bad performance

[Rick James]

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.