Author Topic: High I/O, 96 processes and mariadb is crashing every few minutes  (Read 1071 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
My vps specs are:
1GB memory RAM, 1GB memory swap
2 cores allocated to me from a xeon proccessor
I had half these specs on a shared hosting with the same traffic but nothing ever happened.
Every saod move to vps because it can handle the traffic better than shared but it looks to me that it's the opposite?
Is there any way to optimize my specs with a small WordPress site? It's been virtually down for almost a month

Offline
***
Re: High I/O, 96 processes and mariadb is crashing every few minutes
« Reply #1 on: October 20, 2020, 01:09:01 PM »
Not a big spec., in terms of RAM, especially for running CWP. Dual core helps a lot though.
In making the leap from shared hosting to VPS, you're going to have to learn how to manage a server. CWP can help but it won't replace required knowledge! It is now your responsibility to ensure that the VPS is secure and kept up to date.

Wordpress resources are highly dependent on which extensions, themes etc. are used.
You'll need to fine tune Apache or nginx (run only one of these in 1GB RAM).
You'll also need to tune mysql/maria.
Forget running amavid/clamd/clamav/spamassissin - without exhaustive tweaking these will be a disaster with CWP.

Upgrading to 2GB RAM will make things easier but doesn't take away the need to follow the above points. Perhaps use a different, Wordpress-centric control panel, if that is all you will host.

(I have a backup/failover VPS with single core 1GB RAM, that happily runs a sizable e-commerce application, when the need arises. In quiescent state is has 99 process running; no antivirus/spamassassin)
« Last Edit: October 20, 2020, 01:14:32 PM by cynique »

Offline
*
Re: High I/O, 96 processes and mariadb is crashing every few minutes
« Reply #2 on: October 20, 2020, 01:15:00 PM »
My vps specs are:
1GB memory RAM, 1GB memory swap
2 cores allocated to me from a xeon proccessor
I had half these specs on a shared hosting with the same traffic but nothing ever happened.
Every saod move to vps because it can handle the traffic better than shared but it looks to me that it's the opposite?
Is there any way to optimize my specs with a small WordPress site? It's been virtually down for almost a month

Thanks for your helpful reply, do you know any article/guide on how to optimize it because changing panels isn't a very reasonable option for me because I can't risk more downtime.
Also is it possible to switch from mod_php to php-fpm on free cwp?

Offline
***
Re: High I/O, 96 processes and mariadb is crashing every few minutes
« Reply #3 on: October 20, 2020, 02:32:57 PM »
Just one of many articles, found by Yahoo!:
https://panel.cinfu.com/index.php/knowledgebase/5/Low-RAM-configuration-for-MySQL-and-Apache.html
No size fits all, so you need to experiment/tweak.

Offline
*
Re: High I/O, 96 processes and mariadb is crashing every few minutes
« Reply #4 on: October 20, 2020, 04:06:59 PM »
thanks buddy