Re: 2 GB limit reached

[Dennis]

At 12:09 PM 01/09/2002, Dan Nelson wrote:
>In the last episode (Jan 08), Dennis said:
> > We have a database that seems to have grown too large, and now any
> > operation fails on it. How can we fix this?
>
>If you can SELECT from it, create a new MYISAM table with the RAID
>option, or create an INNODB table with multiple 2gb tablespace files.
>Then "INSERT INTO newtable SELECT * FROM oldtable".
>
>If you can't select from it, you might have to run myisamchk to repair
>the table, or transfer the table to an OS that does not have the 2gb
>limit and split the table there.
>
>--
>         Dan Nelson
>         dnelson@stripped


is the 2GB limit only in linux 2.2? (ie does 2.4 not have that limit?). 
Running a 2.4 kernel is the easiest option in that case.

Dennis