[CentOS] Max Filesize MySQL CentOS 3

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