MySQL
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.
