Look into MAX_ROWS... ie:
alter table mytable max_rows = 100000000
ryan
----- Original Message -----
From: "Nathanial Hendler" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, August 15, 2001 12:19 PM
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
