MySQL database high CPU usage

[wesley700r]

Hi, we have a store running on a dedicated server with Cpanel.
Spec
32GB Ram
2x Intel Quad-Core Xeon E5-2643
2x120 GB SSD

And we are experiencing random high load from Mysql (MariaDB) according to top c it goes to 1300%cpu and our store goes down for about 2 to 10 minutes.

Any advice how we can find out what is causing this?

Thanks

 

[wesley700r]

I have maybe solved the problem already by doing a new installation of MariaDB and some changes to the my.cnf

 

[cPanelMichael]

Hello,

I'm happy to see you were able to see improvements after making configuration changes in your /etc/my.cnf file. You may also find the following thread helpful:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.