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

Xiaobian to share with you how many pieces of data mysql database can store, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

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. In fact, the upper limit of MySQL single table is mainly related to the maximum file size supported by the operating system.

Official introduction:

MySQL 3.22 limits table size to 4GB. Due to the MyISAM storage engine used in MySQL 3.23, the maximum table size increased to 65536TB (2567 - 1 bytes). Because of the larger table size allowed, the maximum valid table size for MySQL databases is usually determined by operating system limits on file size rather than MySQL internal limits. The InnoDB storage engine keeps InnoDB tables in a single table space, which can be created from several files. This allows the table to exceed the maximum size of a single file. Tablespaces can include raw disk partitions, enabling very large tables. The maximum capacity of a table space is 64TB.

In fact, the amount of data MySQL can withstand is mainly related to the structure of the data table, and is not a fixed value. The table structure is simple, then can withstand the data volume is relatively larger than when 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 single table can run well at about 20 million records (4 G), and after database optimization, it can run well at 50 million records (10G).

The above is "mysql database can store how many data" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.