Code: Select all
'ON' => "f.forum_last_post_id = t.topic_last_post_id AND t.topic_moved_id = 0"
Is that load for just your vps or the entire server? 8gb servers are incredibly cheap nowadays, and such a server would fit 32 vpses at 256mb each (what you have allocated).MichaelBuckle wrote: Average load: 6.25; 6.81; 5.81
With 150 concurrent users each needing 2m rows examined I can see how you could bring your box to its knees.We've hitting 100% with about 150 online...
That's in the Plesk control panel so I assume our VPS load, we're happy to upgrade to more Ram, I've emailed the support for them to look into it, but if ram is going to help with the load we're happy to do so.nn- wrote:Is that load for just your vps or the entire server? 8gb servers are incredibly cheap nowadays, and such a server would fit 32 vpses at 256mb each (what you have allocated).MichaelBuckle wrote: Average load: 6.25; 6.81; 5.81With 150 concurrent users each needing 2m rows examined I can see how you could bring your box to its knees.We've hitting 100% with about 150 online...