List:General Discussion« Previous MessageNext Message »
From:Raymond A Jr Jacob Date:June 29 2006 9:21pm
Subject:RE: Client still reports table full
View as plain text  
If I understand the results from SHOW TABLE STATUS LIKE 'data';
My avg_row_length = 497 Why would descreasing it to 50 have a positive
Effect. I would assume I should increase it?

Thank you/Raymond

-----Original Message-----
From: Brent Baisley [mailto:brenttech@stripped] 
Sent: Thursday, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@stripped
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 in the table (blob, text, etc.).

Also, perhaps a silly question which you may have answered earlier, but
does you file system allow files larger than 4GB? Sometimes you have to
specifically enable that feature in a file system.

If that doesn't work, or you're limited to 4GB files, you may need to
switch to using a merge table.

----- Original Message -----
From: "Jacob, Raymond A Jr" <raymond.jacob@stripped>
To: <mysql@stripped>
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=11000000

 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 'data';" | mysql -u user -p snortdb
\ below is the output.

Name Engine Version Row_format Rows Avg_row_length
Data_length Max_data_length Index_length Data_free
Auto_increment Create_time Update_time Check_time
Collation Checksum Create_options Comment
data MyISAM 9 Dynamic 8721565 497 4335220336
1099511627775 127599616 0 NULL 2006-06-28 20:54:55
2006-06-29 18:02:32 NULL latin1_swedish_ci NULL
max_rows=11000000

\\ df shows /var the partition with the database has enoungh room:
Filesystem    1K-blocks     Used   Avail Capacity  Mounted on
....
/dev/amrd0s1f  27792614 18449326 7119880    72%    /var
....

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Thread
Client still reports table fullRaymond A Jr Jacob29 Jun
  • Re: Client still reports table fullDan Buettner29 Jun
  • Re: Client still reports table fullBrent Baisley29 Jun
    • RE: Client still reports table fullRaymond A Jr Jacob29 Jun
      • Re: Client still reports table fullDan Buettner29 Jun
        • RE: Client still reports table fullRaymond A Jr Jacob30 Jun
      • Re: Client still reports table fullBrent Baisley30 Jun
        • Solved: Client still reports table fullRaymond A Jr Jacob1 Jul