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

Editor to share with you that the mysql database can be used to store more big data. I hope you will gain a lot after reading this article. Let's discuss it together.

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

What is the maximum amount of 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 been increased to 65536TB (2567-1 bytes). Due to the larger table size allowed, the maximum valid table size for MySQL databases is usually determined by operating system restrictions on file size, not by MySQL internal restrictions.

The InnoDB storage engine saves InnoDB tables in a tablespace that can be created by several files. In this way, the size of the table can exceed the maximum capacity of individual files. Tablespaces can include raw disk partitions, making large tables possible. The maximum capacity of the tablespace is 64TB.

In fact, the amount of data that MySQL can bear 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 bear is larger than when the structure is complex.

According to the results of the CMS system evaluation done by the D.V.B team and the Cmshelp team, the MySQL single table works well under about 20 million records (4G) and 50 million records (10G) after database optimization.

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 table size allowed, the maximum valid table size for MySQL databases is usually determined by operating system restrictions on file size, not by MySQL internal restrictions.

InnoDB storage engine: the InnoDB storage engine saves InnoDB tables in a tablespace that can be created by several files. In this way, the size of the table can exceed the maximum capacity of individual files. Tablespaces can include raw disk partitions, making large tables possible. The maximum capacity of the tablespace is 64TB.

After reading this article, I believe you have a certain understanding of the mysql database can be used to store more big data, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

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.