 | | | Client still reports table full | Client still reports table full 2006-06-29 - By Brent Baisley
Back
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@(protected)>
To: <mysql@(protected)>
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=brenttech@(protected)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|