What is the maximum size of a MySQL database in version 5 and above?
I do not mean the maximum size of a row or table, but the maximum size of the entire database.
Two billion (2'000'000'000) tables and a maximum of 64 TB for InnoDB. MyISAM tables are files, so this is a limitation for the OS file.
It depends on your operating system. That is, in Windows it depends on the maximum size of the folder.
This documentation entry is very useful regarding this.
MySQL , MySQL.
Operating System File-size Limit Win32 w / FAT / FAT32 2GB / 4GB Win32 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