Do any of you have much experience with mysql? We're running v 3.23 -- this was part of the standard buildout of the ISP who set up the server, and I'm thinking they believe it to be stable.
I'm seeing the big tables get corrupted more and more -- I have to run the myisamchk repair tool to fix them. So far they've been recoverable, but it is worrisome, and occasionally causes a crash (btw, spameater now dies with a TEMPFAIL error code for sendmail, so it's treated as a temporary failure).
The "big" tables aren't that big -- Emails has about 390k records, and Users has about 43k records. They do get positively slammed with updates though.
Any tips on stabilizing this? Upgrading? Switching (PostGres?)?