Database and table 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

Last updated 17 Jul 2011

Return to the Artful MySQL Tips page