| WWW.APPSERVGRID.COM https://www.art2dec.co/fort/ |
|
| What is the largest database size allowed in MySQL? https://www.art2dec.co/fort/viewtopic.php?f=21&t=7385 |
Page 1 of 1 |
| Author: | admin [ Tue Nov 20, 2012 8:33 am ] |
| Post subject: | What is the largest database size allowed in MySQL? |
Answer: It all depends on the type of MySQL database you wish to use and also the operating system the server has. Most of the restraints are due to the max file size the operating system can store. The limits are done by table size rather than the database size as a whole. •Win 32 w/ FAT/FAT32 - 2GB/4GB •Win 32 w/ NTFS - 2TB (possibly larger) •Linux 2.2-Intel 32-bit - 2GB (LFS: 4GB) •Linux 2.4+ - (using ext3 file system) 4TB •Solaris 9/10 - 16TB •MacOS X w/ HFS+ - 2TB •NetWare w/NSS file system - 8TB InnoDB tables are often split up into multiple files to allow larger tables, this is known as a tablespace. The maximum table space is 64TB. MyISAM tables default size is at 4GB, but this can be changed to a maximum of 65,536TB. |
|
| Page 1 of 1 | All times are UTC + 2 hours [ DST ] |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|