PDA

View Full Version : Frequently Crashing MySQL Table


komodo
10-13-2006, 11:03 PM
Hey guys, first time posting in this forum, but I've been lurking for a while, hah.

I have a table that keeps crashing, about 2-3 times a day. It starts returning crazy results from queries (ie, only 1 result for a simple select query, when there should be about 100), and I have to run a repair to fix it.

It's handling about 5 queries a second, non-stop, but that shouldn't be a problem, should it?

Any ideas on what could cause frequent crashes like this?

Thanks! :thumbsup:

-Edit-
It's getting worse, requiring a repair about every hour now.
I've had to halt all my operations until I get this issue resolved, because it's creating bad data.