On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote:
> Nick Seidenman writes:
> > Apparentlly there's a 4 GB limit to a MyISAM file when the table it
> > contains has VARCHAR, TEXT, or BLOB columns. In order to get around this
>
> There is no 4 Gb limit in MyISAM with later 3.23 versions.
I an running version 3.23.32.
> This limit is imposed by a filesystem only.
Don't think so. When I do a SHOW TABLE STATUS I have several tables that are
well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB. The
difference is that the larger tables are of fixed type while the smaller ones
are of dynamic type. It is one of the dynamic tables that repeatedly runs
into space problems. This one happens to have a TEXT column in it the values
for which can be (and often are) in excess of 2 KB.
----------------------------------------------------
Nick Seidenman, CISSP
Director of Software Development
Hyperon, Inc.
www.hyperon.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
