Shulou(Shulou.com)06/01 Report--

What is the single table capacity of MySQL? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

MySQL single table capacity

The single table capacity of MySQL is about 5 million, and the performance is at its best. At this time, the height of the BTREE index tree of MySQL 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.

Since MySQL 3.23, the storage engine of MySQL is MyISAM, and the maximum limit for a single table is 64 PB (67108864 GB).

1 PB = 1024 TB1 TB = 1024 GB

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

Since MySQL 4.0, there are two strategies for MySQL's storage engine to support InnoDB,Innodb to store data:

Shared tablespace storage mode

All the data in Innodb is stored in a single tablespace, which can be composed of many files, and a table can exist across multiple files, so its size limit is no longer a file size limit, but its own limit. Officials say the maximum limit for Innodb tablespaces is 64 TB.

Exclusive tablespace storage mode

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

This is the answer to the question about the single table capacity of MySQL. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.