They added innodb_buffer_pool_size=400MB and we saw an immediate improvement with the load descending from 3 to 0.5. I just wondered if there were any other similar settings.
Also our database is about 2GB in total, would you say 400MB there is a reasonable value?
"Poor performance compared to vB." You say. I'm sorry, but I disagree because xenForo requires less server resources than vB.
That applies to me. I moved my posts from vB4 to xenForo no problem. Didn't hinder my server.I suspect a good number of people migrating to XF do not have InnoDB properly configured (or at least haven't used it previously so have not had the need to tweak it) - I know I didn't use it at all when I was on vB and only used it for a couple of tables when I was on IPB.
That applies to me. I moved my posts from vB4 to xenForo no problem. Didn't hinder my server.
Nope, we get plenty of traffic every day. When I transferred CODForums from vB4 to xf, everyone was anticipating the release of MW3. It was a busy time. I have another website that brings 1,000 views that same day of the transfer. Nothing happened.You probably wouldn't notice it if you only had a few people online. We had no problems on our test boards when we only had our staff online and only started noticing the problems when we went live.
Yes stock vs stock, it took me awhile to get XF running as fast as our vb 4 was. However our XF setup is now faster, mostly thanks to the image sprites.I'm sitting over here looking all confused like this:
"Poor performance compared to vB." You say. I'm sorry, but I disagree because xenForo requires less server resources than vB..
Thread name change ?
Current: Really poor performance compared to VB...
Actual: Poor performance - server setup needs tweaking.
Find your httpd.conf file and post the contents here after sanitizing it. Also, grab a copy of your apc.ini (or load up a page displaying phpinfo and look for your APC settings).mrGTB: We run a football forum so at the end of matches, etc we get quite big peaks as people come on to discuss the match. VB handled it fine after some initial tweaking and we were handling 3000+ users fine. We're struggling with 500 or so at present.
Deebs: I don't know regarding httpd processes. How would I find out? I'm fairly sure it's not 1 per client as we have 500 users online.
What I think is an unrelated issue that's making it worse is that APC seems to reset every 2 hours and when it does that shoots the load up. We just had a "perfect storm" of a load of traffic coming on and APC resetting which put the load over 100. It's back down to 3 or so now and APC is handling 1000 cache requests per second.
View attachment 28396
We use essential cookies to make this site work, and optional cookies to enhance your experience.