UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Dropped Users

My board keeps dying. I get the page full of MySQL errors that renders the board useless. After running mysqlcheck on the database, I get the following:

ubb-realtree.w3t_users
info : Wrong block with wrong total length starting at 2372984
warning : Number of rows changed from 5316 to 5315
status : OK

After this, one of my users is lost. This has happened 4 times in the last few weeks. What can I do to permanently fix this? What's causing it?

It's hard to identify one particular thing it could be without knowing your system and watching it. I'll give you a bunch of "it could be" type things to look at. These are not in any particilar order, FYI.

Check your version of MySQL. There have been a few table corruption bugs fixed lately. 4.0.18 is the most recent. You'll want to be sure you are new than 4.0.14 as it had an idex corruption bug that really hurt a lot of our users.

Are you running low on memory on that database? Is it thrashing to disc too much? Is it out of tune? this discussion and this discussion are great resources to get you going.