I get the following message from my dedicated server:
While processing, the cpu has been maxed out for more than a 6 hour period.
The current load/uptime line on the server at the time of
this email is
07:23:03 up 2 days, 23:42, 0 users, load average: 8.71, 6.63, 6.41
You should check the server to see why the load is so high and take
steps to lower the load. If you want stats to continue to run even with a high load; Edit
/var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run
/usr/local/cpanel/startup afterwards to pickup the changes).
If I run top command from ssh I see that mysqld use 105-125%of CPU.
How may I check which query use so much the CPU ?
█ Michael Vlastos
█ HostWired.com - Innovative Hosting Solutions since 2005 | cPanel, Softaculous
█ Personalized support | No site suspensions | No overloaded servers | Green Hosting
█ Multiple Backups | Average Response Time: 20 min | Toll Free: 1-855-ECO-HOST