ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Mysqld was taking 100 % CPU usage

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.