Maximum storage space supported by a single MySQL table

What is the maximum storage space supported by a single mysql table? The maximum table size of MyISAM is 65536 TB, but before MySQL5.0, a single MyISAM table is allowed by default.

What is the maximum storage space supported by a single mysql table? The maximum table size of MyISAM is 65536 TB, but before MySQL5.0, a single MyISAM table is allowed by default.

What is the maximum storage space supported by a single mysql table?

In fact, this problem has to be split into two problems.

The first is the size of a single file supported by the file system used by the operating system, for example:

Linux 2.2-intel 32-bit (ext2 File System) supports a maximum of 2 GB

Linux 2.4 + (ext3 File System) supports 4 TB

Win32 (fat32 File System) 4 GB

Win32 (ntfs file system) 2 TB

The second is the maximum size of Space supported by the storage engine. For example

The maximum tablespace capacity of the InnoDB Storage engine is 64 TB, which does not limit the size of a single table, but is limited by the tablespace.

The maximum table size of MyISAM is 65536 TB. However, before MySQL, the maximum size of a single MyISAM table is 4 GB by default, you can use the show table status statement or the maximum size of the myisamchk-dv tbl_name checklist. If the size is 4 GB, you can modify the values of AVG_ROW_LENGTH and MAX_ROWS. After MySQL 256, the default MyISAM Table limit is TB. The modification method is as follows:

// Modification method when creating a table
Create table tbl_name (

A integer not null primary key,

B CHAR (18) NOT NULL

MAX_ROWS = 1000000000 AVG_ROW_LENGTH = 32;

// Modify the method of an existing table
Alter table tbl_name MAX_ROWS = 1000000000 AVG_ROW_LENGTH = 15000;