Yee Chuan Loh <[EMAIL PROTECTED]> writes:
> The document at
> http://www.mysql.com/doc/T/a/Table_size.html
> seems to suggest that the reason why there's a limit to the table size is
> because of the number of bytes used by the file system to store offsets,
> so its more or less file system depe
The document at
http://www.mysql.com/doc/T/a/Table_size.html
seems to suggest that the reason why there's a limit to the table size is
because of the number of bytes used by the file system to store offsets,
so its more or less file system dependant (pls correct me if i'm wrong).
It also wrote t
(sql, to fool lame filter)
ryc <[EMAIL PROTECTED]> writes:
> 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=100
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=1000".. (its in the manual)
ryan
> > I have a Linux machine (Linux
Guðmundur Ólafsson <[EMAIL PROTECTED]> writes:
> Hi,
>
> 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 does
Hi,
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. Exact size of the table is:
2039867196 :) So my question is. What h
