All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
What is the Max Concurrent User 2GB can take
My Client runs a Standard VPS Plan from Bluehost 2gb Ram 2core CPU with Wordpress. But over the last few days we have turned a bluehoster, such that I have to reboot the vps at peak of 90-120 user online due to mysql crash. when I run free -m
the free comes down as low as 53. same case last night when there were about 50 users online.
Secondly, I suspected MySQL running the vps out of memory, the database being used for the site was about 67mb and some others unused total about 150mb.
Similar case happen sometimes ago, I have to delete over 2000 post for the VPS to become stable till last week it started again today I have to delete over 2000 post again to get the site running properly. The owner also claimed it was even faster than before.
O yes, I have chatted Bluehost support, it seems like they are a bunch of coffee drinkers doing what I can do by myself [reboot the vps], one told me I have to upgrade ram for 120 Concurrent users.
Enough of my whining,
=> What is the Max Concurrent User 2GB can take
=> What can I do to optimized the site to prevent such occurrence in the future and crashes
=> Am considering installing OpenLiteSpeed as drop-in for Apache on the VPS - is this a good option
Comments
yes
Cache.
Also this and this.
God bless your heart.
Type your comment
God bless you, my child.
OLS is good but won't make as much difference as cache would. I think it's supports LSCache plugin so definitely try that.
Blessings.
Answer: Cache + Auto Services restart on crash (MySQL, Nginx etc etc)
tree fiddy
Replace Apache with NGINX, use mariadb instead of MySQL. Run mysql tuner and use their recommendations wisely .
That VPS should be able to handle more. But, frikking Wordpress is so bloated. Three internal WordPress features (WP-CRON, REST API, admin-ajax.php) can be extremely hard on a server if abused by plugins and themes. (A query monitor will be of no use if the issue is excessive usage of any of these three features ).
Remove anything you don’t need, use some type of caching.
Bottleneck on MySQL ? use REDIS for cache DB
For load testing you can use
https://loader.io/
and see how your VPS performs when let's say 15 users connect per second and then tune your VPS accordingly. By the way if you are using Apache then replace it with nginx as told by seriesn.1 website and 2GB RAM you can get free licence for Litespeed Enterprise with all the .htaccess goodies built in
Totally forgot. Thanks.
You need to check the part that says 'available'.
Before doing any changes on your server, first identify the root cause. You can fetch the root cause from the log file /var/log/messages . Kindly review the log file and check whether any "out of memory" errors are recorded or not.
Loader.io is very good to test. Often goin at 10,000 per minute (max for free account).
Made possible by (open)litespeed.
Since when mariadb is faster than mysql 8? For wordpress percona is the way to go. Nginx? Sure, but litespeed would be a bit better with standard htaccess support.
Faster? Not really, about similar performance with a slightly lighter footprint. Plus, not owned by a big corp who kinda screwed other opensource programs in the past.
Litespeed is definitely better! But is that premium price really worthed for your everyday joe?
FreeBSD please.
Debian tnx.
Why is percona better? I switched from percona to mariadb because it's default in debian.
Percona optimized for InnoDB engine.
I have the impression that the OP (@benYahweh) isn't especially interested in any of the answers (to the extent that they're serious), given that he disappeared right after opening the thread
Although correct, there is no noticeable difference in performance unless the site has heavy traffic. DB caching remains the best approach for small / medium sites, imho.
nginx cache + apache as backend or varnish with apache + wp rocket as a plugin. After that, run mysqltuner.pl (https://github.com/major/MySQLTuner-perl) and use it wisely.
Also one thing people tend to forget about are removing unused PHP modules, only installing the wordpress required PHP modules on PHP7.3 could gain you +-800ms to 2 seconds in load time on average and requires much less resources:
https://wordpress.org/support/topic/which-php-extensions-are-needed-to-run-a-fully-operational-wordpress-site/
most of the above are already in the default Ondrej/PHP repo, an apt-get install php7.3 php7.3-mysql php7.3-opcache(recommended) should be enough.
I was reading the comment in ghost mode, after some chatting, bluehost sysadmin did some stuff that bring the server back to normal, guess what we are back at the same issue.
Also my busy schedule did not afford me the opportunity to keep up with the thread
I think a lot of people have said this, but use Litespeed, cache, and an automated Cronjob (With Crontab or similar) to free memory cache and buffer could help free up some memory.
=> What is the Max Concurrent User 2GB can take
=> What can I do to optimized the site to prevent such occurrence in the future and crashes
=> Am considering installing OpenLiteSpeed as drop-in for Apache on the VPS - is this a good option
Maybe there are just too many bots?
The following I don't recommend but works well fairly easy to do with starters to prevent bots.
But if you are really serious on solving your issue, you need to give more details.
What plugins you have in your site? Is it a very dynamic site or just simple blog? an ecommerce? a forum? multi-site? Also what theme are you using?