Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - serveria

Pages: [1]
1
MySQL / Re: Extreme mysql load!
« 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. 

2
MySQL / Re: Extreme mysql load!
« 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. 

3
MySQL / 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.   

Pages: [1]