MySQL database high CPU usage

wesley700r

• August 18, 2016 01:47

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

  • August 19, 2016 06:47

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

  0
• 

  cPanelMichael

  • August 23, 2016 16:57

  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.

  0

Please sign in to leave a comment.