ailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2003 2:04 PM
To: Jon Wagoner
Cc: [EMAIL PROTECTED]
Subject: Re: table gets corrupted often
Could it be getting larger than 2G on a filesystem with a 2G/file limit?
Jon Wagoner wrote:
>I have a table that tends to get corrupted and needs to be
Could it be getting larger than 2G on a filesystem with a 2G/file limit?
Jon Wagoner wrote:
I have a table that tends to get corrupted and needs to be repaired every
few days. It is used for logging various messages in my web app. The
structure is:
CREATE TABLE log (
log_id int(11) unsigned NO
I think I have tracked the problem down to deletes. In an environment
with many deletes I've noticed that the rate of table corruption across
my cluster of db server increases for the boxes with many deletes.
I've been able to get around this issue by periodically checking tables
on off hours and
