What is the capacity of a single MySQL table?

The capacity of a single MySQL table is about 5 million, and the performance is at its best. At this time, the height of MySQL's BTREE index tree is between 3 and 5; and the maximum limit of a single table is no longer limited by MySQL. Limited by computer capacity.

MySQL single table capacity

MySQL single table capacity is around 5 million, and performance is at its best Status, at this time, the height of MySQL's BTREE index tree is between 3 and 5.

Related introduction:

MySQL single table size limit

In MySQL 3.22, the storage engine of MySQL is ISAM, and the maximum limit for a single table is 4 GB .

Starting from MySQL 3.23, the storage engine of MySQL is MyISAM, and the maximum size of a single table is 64 PB (67108864 GB).

1 PB = 1024 TB
1 TB = 1024 GB

At this time, the maximum limit of a single table is no longer limited by MySQL, but changed by the computer capacity limit.

Starting from MySQL 4.0, the MySQL storage engine supports InnoDB. Innodb’s data storage strategies are divided into two types:

Shared table space storage method

All data storage in Innodb In a separate table space, this table space can be composed of many files, and a table can exist across multiple files, so its size limit is no longer the limit of the file size, but its own limit. Officially, the maximum limit for Innodb tablespace is 64 TB.

Exclusive table space storage method

The data of each table is stored in a separate file. At this time, the single table limit becomes the size limit of the file system.

Recommended: "mysql tutorial"

The above is the detailed content of What is the capacity of a single MySQL table?. For more information, please follow other related articles on the PHP Chinese website!