I'm not an SQL expert but if FreeBSD supports > 4GB files than you should
check your "MAX_DATA_LENGTH" properties on the table you're using. You can
do this by running SHOW TABLE STATUS on the table. I believe you can use
ALTER (or on create table statements) to change this value.
Hope this helps, here's a pointer to more information on this:
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#
Table_size
- Trevor
-----Original Message-----
From: Nathanial Hendler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 10:20 AM
To: MySQL
Subject: Table size limitations...
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
---------------------------------------------------------------------
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