I completely rewrote the code that moves stuff into the archive, which allowed me to move the archive date up to about nine months ago. Stuff older than that is all now archived. This moved over 48,000 stories and some unholy number of comments out of the active database, which ought to help with the speed a lot. More importantly, it means the archive can keep up day-to-day, so it might be a little while before the next collapse.
I do have to admit that I screwed up a little in an intermediary attempt at the archive fix, and managed to lose some stuff. I had to recover from a backup made yesterday afternoon, and the site was up for a fairly brief period after that backup, so there may be a few comments lost. If you're missing something you managed to post through all the trouble yesterday, I'm really sorry. I hate when that happens. It shouldn't be very much stuff though.
We're still running on one Scoop server, the other being live but lacking ssh access. I need to get into it and restart Apache before it will come back into the pool, and that will require someone at the colo to walk up to it and start sshd. It certainly ought to be back up in the next day or so at most, and I'm hoping the freshly-scrubbed database can help make up for it till then.
Update [2003-7-9 19:0:16 by rusty]: The other Scoop box is back up, so we have returned to full power. Thanks Voxel!
In other news, I'll have the K5 store up for real tomorrow, if there aren't any more fires to put out. The shirts are in stock at Jinx, and they look pretty good.
So what did you do on your day off?