I had a similar problem with an Oracle database once. It turned out to be some memory in the process of going bad.
John -----Original Message----- From: Jon Wagoner [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 2:24 PM To: [EMAIL PROTECTED] Subject: RE: periodic corruption problem It's been going on for months, so that doesn't seem very likely. On the other hand, we have had 2 or 3 other hard drives go bad with other servers at this host, so I'm not ruling it out. -----Original Message----- From: Big Brother [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:04 PM To: Jon Wagoner Cc: [EMAIL PROTECTED] Subject: Re: periodic corruption problem my experience with corrupted tables is usually followed by a failed harddrive ....aka the disk may be diing ... -- Quoting Jon Wagoner <[EMAIL PROTECTED]>: > I am running MySQL 4.0.16 on a Red Hat 7.3 server. I am having problems > with tables periodically getting corrupted. The one it happens most often > on is a table I use for logging various status messages. This table > receives mostly inserts, and very few selects. It is about 400MB in size, > with about 1.3M rows. I just had it happen to another table, that receives > mostly selects, and few inserts or updates. It is only about 60MB in size, > with about 95k rows. Both of these tables rarely have deletes. > > The last time, I believe the error message said something about the index > being the wrong size. Sorry I didn't write it down, but I was in a hurry to > get things working again. Can anyone provide some help on this problem? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]