Schlemmer wrote:"Sorry but you cannot use search at this time. Please try again in a few minutes."
Am I the only one getting this past couple of days? From any of the quick links, view new posts / view your posts, etc.
After the web hosts yelled at us, I set it to disable if the server load goes above 3, as the search can be expensive on the database. Meanwhile, I'm trying to optimize the code so the server load never goes above 3.
Server load represents, more or less, the number of processors being fully used. The server has 2 processors, so if we're using 3 processors worth of processing, then it means there is going to be a lot of waiting for all tasks to go through, resulting in massive slowdowns.
So anyway, the idea is to try to automate the disabling of some services, like search, when load is high so as not to create a traffic jam, and at the same time try to figure out how to reduce load so it rarely gets that high.
Today, I moved the session tables to memory. Every time a page loads on here, for every user and even every guest, it writes to the session table to store their activity for crap like "Who's Online." I think this should have a big impact as that was a lot of small writes to the DB.
Let me know how often you find search unavailable in the future.