: Thursday, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Oops, left out an important part. You should change the Avg_row_length
also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic
Hmmm ... several references online make it sound like that's all you
should need to do (the alter table statement, that is).
My next step would be to try a 'CHECK TABLE data QUICK' to see if it
reports anything unusual. If it does, issue a 'REPAIR TABLE data'
command. If check table quick
Oops, left out an important part. You should change the Avg_row_length also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic length fields in
the table (blob, text, etc.).
Also, perhaps a silly question which you may have answered earlier, but
, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Oops, left out an important part. You should change the Avg_row_length
also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic length
fields
Effect. I would assume I should increase it?
Thank you/Raymond
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Oops, left out an important part. You
]
Sent: Thursday, June 29, 2006 17:55
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Client still reports table full
I'm not sure that avg_row_length has a bearing on your problem right now
... the output of show table status you posted earlier shows that you
have:
current data
