Mark,

----- Original Message ----- From: "Mark Maggelet" <[EMAIL PROTECTED]>
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



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to