: 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
Baisley [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 8:49
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Wow, I'm really sorry about that. Left out a zero. I should stop
answering questions before the holiday weekend.
I was suggesting a minor
Yesterday:
I ran the following command:
ALTER TABLE data max_rows=1100
Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I still get the table is full error on the data table.
I ran the command:
\ echo SHOW TABLE STATUS LIKE
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
]
To: mysql@lists.mysql.com
Sent: Thursday, June 29, 2006 1:37 PM
Subject: Client still reports table full
Yesterday:
I ran the following command:
ALTER TABLE data max_rows=1100
Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I
, 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