Hi JC, From http://www.mysql.com/doc/en/Table_size.html (I searched on size)
If you need bigger tables than 4G (and your operating system supports this), you should set the AVG_ROW_LENGTH and MAX_ROWS parameter when you create your table. See section 6.5.3 CREATE TABLE Syntax. You can also set these later with ALTER TABLE. See section 6.5.4 ALTER TABLE Syntax. FreeBSD supports terabyte files/filesystems, use the MAX_ROWS parameter and set it to some really large value (anything over 2^32 like 100000000000). This ALTER statement will cause your indexes to be rebuilt using long pointers. You can also create the table this way using MAX_ROWS option in create statement. You can verify your changes by running SHOW TABLE STATUS before the change then again after the change, watching Max_data_length. Hope this helps, Ken ----- Original Message ----- From: "JC" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 1:45 PM Subject: 2**32(4GB) problem on FreeBSD > Hello Everyone, > > I have a strange situation in that MySQL 3.23.49 on FreeBSD 4.6 > installed from the ports collection seems to be having an issue with 4GB > files. When I issue a checktable I get back the message of > Datafile is almost full, 4026103700 of 4294967294 used. > I thought this odd because I just saw a posting from Jeremy in Apr anonouncing > that they have a 9GB MYD, but that was Linux. > > Is anyone else having this kind of a problem? > Is there any way to dump the compile time options? > > Thanks, > > JC > > -------------------------------------------------------------------- - > 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
