MySQL corruption

[Anon]

Hello people,

I have this major kinda problem. Some (huge) tables of the database of our internet project keep getting corrupted. Actually they sometimes crash! Anyone who can tell me anything about bugs in mysql or possible hazards in multiple users using large (200K+ field) tables?

Thanx in advance!

[Anon]

First, I assume you mean 200k rows and not fields per row.

I'm not a mySQL expert but I did run across this warning on the mysql.org site and it might pertain:

Linux Advisory: Several of our users have reported random table corruption with Linux kernel 2.2.14 under heavy load. The table corruptions went away after an upgrade to a newer kernel. It appears that version 2.2.14 of the Linux kernel has a bug in the I/O implementation. Under some rather rare circumstances, the kernel will write incorrect data to the disk.

We recommend that all users currently running Linux kernel version 2.2.14 upgrade to the most recent version, which is of this writing, version 2.2.19.

[[deleted]]

Define corruption, define crash, what happens?