RE: table gets corrupted often

2003-11-03 Thread Jon Wagoner
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

Re: table gets corrupted often

2003-11-03 Thread gerald_clark
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

RE: table gets corrupted often

2003-11-03 Thread Dathan Vance Pattishall
48 AM -->To: [EMAIL PROTECTED] -->Subject: table gets corrupted often --> -->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 ( --> l

table gets corrupted often

2003-11-03 Thread Jon Wagoner
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 NOT NULL auto_increment, log_type tinyint(1) unsigned NOT NULL default '0', when datetime