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