Not to bitch, whine, or otherwise cause a ruckus . . .
But does anyone have any facts on the outage? Lance Armstrong quit pedaling? Hamsters quit running in the wheel? Cecil take off his tin-foil hat?
Tripler
Enquiring minds want to know.
An explanation.
Aaah. Thanks.
Tripler
P’raps more importantly, can we avoid it again?
How impractical would it be to, let’s say:
Backup (and lock) all threads that are inactive for x-period of time to another server, (perhaps in some other format) to lighten the load on the board? Searches could then be directed to “the archives” first, before taxing the board’s server itself.
Delete any thread that’s been locked with less than x-number of replies? (I’m thinking here of multipost OPs, or trolling OPs that were locked quickly after being posted.)
I’m almost positive I’ve read one of the mods/admins post something relative to this, about bringing such threads to thier attention for just such a purpose, but I’m a bit squeamish about performing a large scale search after the past couple days. Board access will be heavy enough tonight/tomorrow morning as it is, I think. Anyone recall what I’m thinking of?
Trouble is deleting a thread is (if I understand correctly) itself a serious hit on the server since it involves not only removing the thread from the database, but removing all references to it from the search index. I think I’m right in saying that this is why bad/pointless/illegitimate threads usually get locked rather than deleted.
You know, I left with 3790 posts. Now 15 have been knowcked off, and I can’t recall each thread I had posted in.
Sigh…
I am just happy we are all back!
Lets hope it doesn’t happen again-maybe the hamsters want chocolate?
Right - I posted why this was, but ironically I think it was lost. Anytime you have to unindex words from the Search table it sloooooooows things down.
What could be done, to speed the Board up, is have the Mods copy and paste the thread ID in a post in their private area, or offline. Then, have the SDMB go down for one day every month, where Jerry executes a big old row of deletes (they could be put into one big honkin’ script, perhaps), and re-indexes the Search. A once-a-month thing like that might help to yield a significant overall speed increase; however, it likely would take more of Jerry’s time than the Reader pays him for.
Anthracite: I should have waited a few minutes to post. After thinking it through a little more, this was the qualifier (or at least real close to it) I should have added to my ideas above.
Oh-thank you! For the link to the Uno thread! Much help.
Youre nice.