The default at table creation is 4GB. You can change the default vaule via an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS. MAX_DATA_LENGTH is the product of the two. http://www.mysql.com/doc/T/a/Table_size.html
Regards, Bhavin. ----- Original Message ----- From: "Henry Hank" <[EMAIL PROTECTED]> To: "mysql mailing list" <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 7:05 AM Subject: Max_data_length question... > > Hello, > > While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem > to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any > dynamic tables are limited to 4GB in size? My fixed tables do not show this > problem, and report that their Max_data_length is 4+ billion records times > their record length (as expected). I'm using mysql version 3.23.41 on Red Hat > Linux 7.2. > > Thanks, > -Hank > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > --------------------------------------------------------------------- > 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
