mysql - MyISAM DB 可以存储多少数据？

Question

MyISAM DB 可以存储多少数据？
你们能说出多少结核病吗？

Answer 1

很多都在这些限制之内: http://dev.mysql.com/doc/refman/5.1/en/limits.html

同样来自手册

http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html

There is a limit of 2^32 (~4.295E+09) rows in a MyISAM table. If you build MySQL with the --with-big-tables option, the row limitation is increased to (2^32)^2 (1.844E+19) rows. See Section 2.17.2, “Typical configure Options”. Binary distributions for Unix and Linux are built with this option.

只是为了好玩:每行可以有 65536 字节。这意味着您可以创建 5461 个 LONGTEXT/LONGBLOB 列，每个列能够存储 4GB 的数据。现在乘以 2^64...

但这只是严格的理论数字。