mysql| Data | database
Don't worry-talk about the maximum volume of MySQL database
In MySQL's reference manual "How Can the big could MySQL Tables be?" section, we can know the following information.
The maximum table size for MySQL version 3.22 is limited to 4GB (4 gigabyte). MySQL version 3.23 using MySQL form
, this limit is 800TB (2^63 byte) of the huge scale!! What magnitude concept is 800TB? Actual comparison
Yahoo's huge search engine database is still not (never possible) more than 30TB, then we count as 30TB
, this is to say that MySQL single table size is approximately equal to Yahoo search engine database 26.7 times times!!!
The manual also says that the actual limitations depend more on the operating system's file volume limits. This sentence is the main problem.
In the Csdb MySQL version and the MySQL mailing list Many people ask how big is the disk limit on Windows? This question
It really makes me wonder, isn't there a Windows 2000 release book? In order to relieve everyone's concern, I simply say
If the disk is managed using the NTFS format, then the file volume is 2^64 byte, i.e. 16EB,1EB equals 1024
TB, then I guess you don't have to worry about database size now, do you? The numbers above discuss a single table,
A single file limit, MySQL a table requires 3 files, and a library can contain unlimited tables, so you
Concerns about the lack of database space can be dispensed with. Anyway, I am a few life is not worried:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
