|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.
Last updated 17 Jul 2011