[CentOS] Max Filesize MySQL CentOS 3
Francesco F
franco at inpe.unipi.it
Tue Jan 17 07:42:19 UTC 2006
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
More information about the CentOS
mailing list