Re: Max_data_length question...

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" <henryhank@xxxxxxxxx>
To: "mysql mailing list" <mysql@xxxxxxxxxxxxxxx>
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 <mysql-thread113421@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-bvyas3=comcast.net@xxxxxxxxxxxxxxx>
> 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 <mysql-thread113426@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php