Database and table size size limits

from the Artful MySQL Tips List


Database size limits in MySQL are mostly determined by the underlying operating system.

The current default MyISAM table size limit is 256 terabytes (256 * 2 48 bytes). It can be exceeded by setting MAX_ROWS in the CREATE TABLE statement, up to 64 petabytes (64 * 2 50 bytes).

InnoDB is limited to 64 terabytes (64 * 2 40 bytes).

For discussion of MyISAM table size limits in earlier versions of MySQL, see http://jeremy.zawodny.com/blog/archives/000796.html.



Return to the Artful MySQL Tips page