How many pieces of data can mysql store?

MySQL is one of the databases commonly used by small and medium-sized websites, but many people do not know how much data MySQL can support. I will take you through it below.

#In fact, the upper limit of a single MySQL table is mainly related to the maximum file size supported by the operating system.

Official introduction:

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 withstand 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.

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