How much data can mysql store?

MySQL is one of the databases commonly used by small and medium-sized websites. However, many people do not know how much data volume MySQL can support. In addition, some domestic CMS manufacturers shift the responsibility of data carrying capacity to it, resulting in Many webmasters who don't understand MySQL have a lot of misunderstandings about it. So, how much data volume can MySQL support? In fact, the upper limit of a MySQL single table is mainly related to the maximum file size supported by the operating system.

What is the maximum size of a MySQL table?

MySQL 3.22 limits the table size to 4GB. Due to the use of the MyISAM storage engine in MySQL 3.23, the maximum table size has increased to 65536TB (2567 – 1 byte). Due to the larger allowed table sizes, the maximum effective table size of a MySQL database is usually determined by operating system limits on file size, rather than by internal MySQL limits.

The InnoDB storage engine stores InnoDB tables in a table space, which can be created from several files. In this way, the size of the table can exceed the maximum capacity of the individual files. Table spaces can include raw disk partitions, making very large tables possible. The maximum capacity of a table space is 64TB.

In fact, the amount of data that MySQL can sustain is mainly related to the structure of the data table and is not a fixed value. If the structure of the table is simple, the amount of data it can withstand is relatively larger than if the structure is complex.

According to the results of the CMS system evaluation conducted by the D.V.B team and the Cmshelp team, MySQL can run well with about 20 million records (4G) in a single table, and 50 million records after database optimization (10G) runs well.

Summary:

Mysql: MySQL 3.22 limits the table size to 4GB.

MyISAM storage engine: Maximum table size increased to 65536TB (2567 – 1 byte). Due to the larger allowed table sizes, the maximum effective table size of a MySQL database is usually determined by operating system limits on file size, rather than by internal MySQL limits.

InnoDB storage engine: InnoDB storage engine saves InnoDB tables in a table space, which can be created from several files. In this way, the size of the table can exceed the maximum capacity of the individual files. Table spaces can include raw disk partitions, making very large tables possible. The maximum capacity of a table space is 64TB.

The above is the detailed content of How much data can mysql store?. For more information, please follow other related articles on the PHP Chinese website!