Re: big table corruption

[Mark Maggelet]

Thanks Heikki,
check table gives me this:
mysql> check table resourcesback;
+------------------------+-------+----------+----------------------------+
| Table                  | Op    | Msg_type | Msg_text                   |
+------------------------+-------+----------+----------------------------+
| edplanet.resourcesback | check | warning  | Table is marked as crashed |
| edplanet.resourcesback | check | error    | Found 91296 keys of 91297  |
| edplanet.resourcesback | check | error    | Corrupt                    |
+------------------------+-------+----------+----------------------------+
mysql version is: mysql-standard-4.0.21-pc-linux-i686
but I had similar problems with:
mysql-standard-4.0.18-pc-linux-i686 and
mysql-standard-4.1.1-alpha-pc-linux-i686
show create table says:
CREATE TABLE `resourcesback` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `keywords` text NOT NULL,
  `description` varchar(255) NOT NULL default '',
  `rating` tinyint(4) NOT NULL default '0',
  `grade` set('Pre-K','K-2','3-5','6-8','9-12','Higher Ed') default NULL,
  `media` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  `imageexists` enum('Y','N') NOT NULL default 'N',
  `imagewidth` int(11) NOT NULL default '0',
  `imageheight` int(11) NOT NULL default '0',
  `controversial` enum('Y','N') NOT NULL default 'N',
  `contents` set('audio','video','images') default NULL,
  `timelinestart` int(11) NOT NULL default '0',
  `timelineend` int(11) NOT NULL default '0',
  `reviewer` varchar(255) default NULL,
  `day` date default NULL,
  `status` varchar(255) NOT NULL default 'active',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`),
  KEY `media` (`media`),
  FULLTEXT KEY `title` (`title`,`description`,`keywords`)
) TYPE=MyISAM
OS is RedHat 9 - 2.4.20-8smp
I'd rather not upload the crashed table because it is really big and it 
has some sensitive data.

Thanks,
- Mark
Heikki Tuuri wrote:
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]