In the past that only created errors elsewhere.The too many connections errors sounds like a server limitation related to MySQL.
You may want to look at increasing the value.
We run a site on 4GB of RAM and we may have up to 200 active members at a time and everyday around the same time we crash. Locked transactions and too many connections errors.
We have 3,000 members and about 950,000 posts.
Ow, 400~ simultaneous online and not hitting 2GB of ram?We have 1.7M posts, and ~400 active users on quite regularly and don't even hit 2gb ram usage.
Ow, 400~ simultaneous online and not hitting 2GB of ram?
All your web server (apache/nginx/litespeed), mysql server, elastic search, php, other other caching software are all in the same single Box?
Nah that's impossible.
ES alone takes 512MB to 2GB of ram with your post.
And for 1.7M post you should allocate more than 2GB of ram for Innodb Engine.
So I don't think what you said is true, sorry.
Does the 2 GB statistic still hold true for the web server? If so, do you mind saying which http daemon you use and how PHP is invoked? I'm beginning to wonder if we have enough RAM as well, and it'd help to have a comparison.No your right, I completely miss read. Ignore me, our MySQL and ES are indeed offloaded.
Does the 2 GB statistic still hold true for the web server? If so, do you mind saying which http daemon you use and how PHP is invoked? I'm beginning to wonder if we have enough RAM as well, and it'd help to have a comparison.
With Nginx+SPDY/PHP-FPM I got excellent performance minus all that cost for LitespeedLitespeed using LSAPI
With Nginx+SPDY/PHP-FPM I got excellent performance minus all that cost for Litespeed
@Slavik - What configuration would you recommend-
1. A single box with X GB of RAM
2. Two Boxes with x/2 RAM each dedicated to DB and Litespeed?
Hmm, could you share more information about 'it depends' part? What factors are we talking about? My setup is typical xenforo with a few custom addons.It really is a matter of "it depends".
For 99% of people, keeping things on 1 server is going to be the easiest and best solution.
It depends... are both servers hosted in the same data center and on a private network?Hmm, could you share more information about 'it depends' part? What factors are we talking about? My setup is typical xenforo with a few custom addons.
Hmm, could you share more information about 'it depends' part? What factors are we talking about? My setup is typical xenforo with a few custom addons.
We use essential cookies to make this site work, and optional cookies to enhance your experience.