Extreme mysql load!

Hi guys,

We're a web-hosting company helping our customer to migrate. This is our first experience with CWP and it seems like it's a great control panel but...   before the migration the customer was complaining mysql load was too high. We installed CWP from scratch with MariaDB 10.1.19 and migrated the website but the load is still there. I mean it's really huge ~700-900%CPU. We tried some mysql tweaks but they don't seem to work. We tried moving as much as possible into RAM and ram usage increased from 0.1%, 0.2% etc to 4-5% (running top command) so caching works but it doesn't seem to affect cpu load - it's still huge! Even when the number of php processes is not so big only ~15-20 server load is ~25-30% and %CPU is ~400! The server is a dual hexa-core Xeon with 64GB ram and more than 30GB are available!

We're at a loss here really close to wiping everything and installing cpanel. Please assist.   

may be the server is under dos attack check logs.

Thanks for a speedy response! Which exactly logs do we need to check? I doubt it's a ddos as I mentioned there aren't many php processes visitors/php processes. Apache + NGINX + Varnish are doing a good job to handle the load. 

havent ddos?

your server should be checked by experiences server admin since there are many things that need to be checked.
The best would be that you try to contact some of your system admins or our managed support if you don't have a server admin  for linux.

We have experienced enough admins still they weren't able to pinpoint the issue. This was a time-sensitive project so we had to act fast: we reinstalled the OS from scratch and installed cPanel. The load is now back to normal. Thanks for your assistance. 

Hi guys,

We're a web-hosting company helping our customer to migrate. This is our first experience with CWP and it seems like it's a great control panel but...   before the migration the customer was complaining mysql load was too high. We installed CWP from scratch with MariaDB 10.1.19 and migrated the website but the load is still there. I mean it's really huge ~700-900%CPU. We tried some mysql tweaks but they don't seem to work. We tried moving as much as possible into RAM and ram usage increased from 0.1%, 0.2% etc to 4-5% (running top command) so caching works but it doesn't seem to affect cpu load - it's still huge! Even when the number of php processes is not so big only ~15-20 server load is ~25-30% and %CPU is ~400! The server is a dual hexa-core Xeon with 64GB ram and more than 30GB are available!

We're at a loss here really close to wiping everything and installing cpanel. Please assist.

I experienced the same when upgrading MySQL to 5.6.35.

It seems that the new MySQL version per default has performance scheme enabled.

Just disable performance scheme in my.cnf by adding the line

performance_schema = 0

Then restart mysql and thats it (unless other things in your environment is influencing the high load)