What is the maximum size of a MySQL database in version 5 and above?

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.

+5
source share
4 answers

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.

+3
source

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.

+3
source

MySQL , MySQL.

+2

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

+2
source

All Articles