Re: Random table crashes with 5.0.x in production

[Beat Vontobel]

Keith Miller wrote:
> I have the same problem.
> Not sure what is causing this, but if i write a
> PHP script that iterates through all my databases
> and does a CHECK TABLE on each table with each
> database, it seems to cause table corruption,
> usually on just a few of the bigger tables. It
> does so fairly consistently.
> I am running on a Dual Xeon 3.4GHz with 4Gb of
> memory (most of which is allocated to mysql
> caching), and binary AMD64 distribution of 5.0.15.

Mmh... at my site it never happened again since my last post. But we're on 5.0.18 right now. And things have stabilized quite a bit anyway since 5.0.15. And then of course I don't run my CHECK TABLE script anymore that frequently (probably something similar to your PHP script, just in Perl).