I have a table which keeps getting corrupted, and it is the only one which is affected (and we have quite a few - all which are accessed and updated regularly). I am using stock 3.23.29a-gamma (tarball) on a rh 6.2 linux system and myisam tables.

The table in question is used for our mail system (Qmail patched to authenticate/deliver through mysql), and is becoming corrupted quite often now. Can anyone provide me with any hints on determining where/when the corruption is occuring, or if there are any known similar side affects.

Here is the table:

CREATE TABLE virtual ( id int unsigned auto_increment primary key, user_id int unsigned default 0 not null, username varchar(64) default '' not null, ext varchar(128) default '' not null, virtual_username varchar(32) default '' not null, cost int unsigned default 0, pri tinyint unsigned default 0, flag int unsigned default 0, KEY virtual_username (virtual_username) );

Regards,