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.
Pages: [1]
1
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.
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]
