Don't worry - talk about the maximum volume of MySQL database
In the Mysql Reference Manual "How big can mySQL TABLES BE?" As we can know the following information. The MYSQL 3.22 version is limited to 4GB (4 Gigabyte). Mysql 3.23 Version Use the MySQL form, this limit is 800TB (2 ^ 63 bytes) huge scale! ! What is the level concept of 800TB? In fact, Yahoo huge search engine database is still not (never possible) more than 30TB, then we count for 30TB, this is to say that the size of the MySQL single table volume is about 26.7 times equals the Yahoo search engine database! ! !
In the manual, the actual restriction is more dependent on the operating system to file volume limitations. This sentence is the main problem. Many people in the 9CBS mysql version and MySQL have a lot of people ask how much disk limit on WINDOWS? This problem does make me wonder, do you have any WINDOWS 2000 release book? In order to avoid your concerns, I simply say that if you use the NTFS format management disk, then the volume of the file is 2 ^ 64 bytes, that is, 16EB, 1eb is equal to 1024TB, then I want everyone to worry about the database size. ? The top of the top is discussed with a single table, a single file limit, a MySQL a table requires 3 files, and a library can contain unlimited tables, so you can except for the concerns of database spaces. Anyway, I am not a few people :)
