MySQL Forums
Forum List  »  Performance

Re: High CPU usage after migration
Posted by: Peter Brawley
Date: September 06, 2022 08:55PM

MySQL version(s)?

For starters, consider ...

1 Compare my.cnf settings of the two MySQL instances.

2 How much RAM on the two machines?

3 During a high CPU event execute ...

SHOW ENGINE INNODB STATUS;

SHOW FULL PROCESSLIST;

4 https://www.percona.com/blog/2020/04/23/a-simple-approach-to-troubleshooting-high-cpu-in-mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
64
September 05, 2022 02:54AM
31
September 05, 2022 04:53AM
Re: High CPU usage after migration
21
September 06, 2022 08:55PM


Sorry, only registered users may post in this forum.

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.