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?
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
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>
Sent: Thursday, June 29, 2006 1:37 PM
Subject: Client still reports table full
I ran the following command:
ALTER TABLE data max_rows=11000000
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
\\ 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