Author Topic: Extreme mysql load!  (Read 2810 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Extreme mysql load!
« on: November 24, 2016, 10:56:46 PM »
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.   

Offline
*****
Re: Extreme mysql load!
« Reply #1 on: November 25, 2016, 08:20:27 AM »
may be the server is under dos attack check logs.

Offline
*
Re: Extreme mysql load!
« Reply #2 on: November 25, 2016, 11:03:28 AM »
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. 

Offline
***
Re: Extreme mysql load!
« Reply #3 on: November 26, 2016, 02:12:11 PM »
havent ddos?

Offline
*
Re: Extreme mysql load!
« Reply #4 on: November 30, 2016, 05:50:43 PM »
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.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Extreme mysql load!
« Reply #5 on: December 01, 2016, 08:04:34 AM »
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. 

Offline
*
Re: Extreme mysql load!
« Reply #6 on: December 22, 2016, 02:47:57 PM »
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)