Do the logs that smf generates in the db have any other purpose than to just tell what errors occurred when and what activity goes on in the vault? Stripping some of those could save space and unclog the db, at least a little bit.
I'm pretty good with php and sql. I wrote two [simple] websites using them (and slightly customized a smf 2.0 on the second site). Only if you want me back, though...
Pretty much. I clean those semi-regularly.
Brawl Vault also creates a huge log, part of which is devoted to the report management system. (And I can't stress enough how much I hate that such a bloated system was even required in the first place) Any resolved report (and non-report data) is removed semi-regularly.
As far as I can tell, the big problem we have is with the forum itself. With the amount of users / simultaneous connections, the server times out on certain requests (sometimes halfway through an operation). Miacis's guess on 'illegal operations' accumulating is, as far as I can tell, an accurate description of the problem.
The smaller problems (anything not directly dealing with our over-burdened server) should be helped by running the General Maintenance stuff in the
Forum Maintenance section. Some of these are likely server / DB intensive processes and should not be run during our busy hours.
(Edit: Just ran the table optimizer, it didn't do much
Moderation log can be cleaned out unless we have any issues to resolve there.
And I'm currently running find/fix errors.
We could try the recalculate one later... which will likely screw with anyone's custom post counts.
)