Mark,
----- Original Message -----
From: "Mark Maggelet" <mark@stripped>
Newsgroups: mailing.database.myodbc
Sent: Monday, January 03, 2005 8:36 PM
Subject: big table corruption
> Hi,
> I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
> on it. The table gets corrupted every 1 week or so and I have to repair
> it. I've tried upgrading to newer versions of mysql 3 times but the
> problem persists. I think it may have something to do with the raid 1
> mirror but I can't really tell.
>
> Does anyone have any ideas?
it should not get corrupt. Please file a very detailed bug report to
bugs.mysql.com, if you are willing to upload the corrupt files via ftp for
further analysis.
What does CHECK TABLE print about the corruption? What MySQL version? What
is SHOW CREATE TABLE like? What OS?
> Thanks,
> - Mark
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
