On Thu, 10 Jan 2002, Dan Nelson wrote: > In the last episode (Jan 11), Manish Mehta said: > > As we know that MySql support maximum of 4 GB data per table. > > Actually, http://www.mysql.com/doc/T/a/Table_size.html says that only > Mysql 3.22 had a 4gb table size. With 3.23, the real limit is how big > a file your OS can handle.
Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB limit (32 bits). You can set flags on the table to allow a 64-bit table, and you'll generally hit an OS or physical limitation long before you run out of space. The downside of the 64-bit version is it's considerably slower. Better to split large datasets up into sub-4GB units. james montebello --------------------------------------------------------------------- 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