On 16/01/2006 19.44, John Hinton wrote:> Anybody offhand know the maximum filesize for a MySQL table?
>
> CentOS 3.6
> Linux native ext3 filesystem
> MySQL version 3.23.58
>
From Mysql Manual (http://dev.mysql.com/doc/refman/4.1/en/table-size.html)
Linux 2.4+ (using ext3 filesystem) 4TB
[...]
By default, MySQL creates MyISAM tables with an internal structure that
allows a maximum size of about 4GB. You can check the maximum table size
for a MyISAM table with the SHOW TABLE STATUS statement or with
myisamchk -dv tbl_name. See Section 13.5.4, ?SHOW Syntax?.
If you need a MyISAM table that is larger than 4GB and your operating
system supports large files, the CREATE TABLE statement supports
AVG_ROW_LENGTH and MAX_ROWS options. See Section 13.1.5, ?CREATE TABLE
Syntax?. You can also change these options with ALTER TABLE to increase
a table's maximum allowable size after the table has been created. See
Section 13.1.2, ?ALTER TABLE Syntax?.
Francesco