I have a table that holds a lot of information. I tried to INSERT something
into it, and received...
DBD::mysql::st execute failed: The table 'fancy_big_table' is full at
./tom_to_mutt.pl line 156.
The table is 4G is size. The table's Max_data_length = 4294967295 (4G)
I'm running the MySQL server on a FreeBSD system, and this is not a file
system limitation. I am using MyISAM tables.
So, I'm not sure what to do. I could easily double the size of that table in
the next few months. After reading the CREATE TABLE page in the manual, I
thought that increasing the AVG_ROW_LENGTH would help since it says
that...
"MySQL uses the product of max_rows * avg_row_length to decide how big the
resulting table will be"
I ran "ALTER TABLE fancy_big_table AVG_ROW_LENGTH = 9482;" and after a long
time, it finished without error, but inspecting the Avg_row_length and the
Max_data_length afterwards showed no change. Maybe this is a red herring,
and totally down the wrong path. I'm not sure.
So, if one of you could help me figure out how to cram more crap into my
table, I'd be awefully appreciative.
Thanks,
Nathan Hendler
Tucson, AZ USA
http://retards.org/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
