Hi All,
I’m facing 100 % CPU usage in mysqld & my Config is:
64Gb Memory
32 Core
Looking for suggestions on how to optimize it.
Thanks.
If you are not sure what is the cause for high usage you can start by analysing usage statistics on your Innodb cluster.
Try this first to find out open views & if you have actually used all your resources.
SHOW ENGINE INNODB STATUS;
If this is due to some recent operation, please post more details about it.