If you want a MyISAM table to grow larger than 4GB you have to do
alter table tablename max_rows=100000000
or maybe its 'maxrows'...
Once you do that, you will be able to stuff the table as full as the OS will
let you.
Innobase will allow you to get around this by making a bunch of smaller
files to create a larger table space... but keep in mind the max size for a
blob is 4GB.. (yah that is pretty damn huge tho heh). Im not sure what the
max size for a MyISAM blob is.
Hope this helps.
ryan
----- Original Message -----
From: "Nick Seidenman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 04, 2001 9:54 AM
Subject: Re: Thinking of switching from MyISAM to InnoDB
> 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
>
---------------------------------------------------------------------
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
