The OS may not have a 2GB limit, however the table MAY. If you do a
myisamchk on the table it will tell you if you are running out of space in
the table. If you are.. you need do something like "alter table tablename
max_rows=10000000".. (its in the manual)
ryan
> > I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8
> > 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and
> > now I have a table that is getting VERY near to the ext2 filesystem
> > limitation of 2gb.
>
> Ext2 doesn't have a 2 GB limit. You seem to be running Red Hat Linux
> 7.1, and both kernel and C library support large files on this system.
>
> For more information, I recommend a look at
> http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html
> --
> Trond Eivind Glomsrød
> Red Hat, Inc.
---------------------------------------------------------------------
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
