mysql - 解决MySQL表大小限制问题

Question

我有一个包含大量数据且频繁添加行的表。

如果将来达到表大小限制，那么如何处理这个问题？ MySQL数据库表的最大大小是多少？

Answer 1

If in future, table size limit reached then how to handle thisproblem?

您可以使用分区

https://dev.mysql.com/doc/refman/5.7/en/partitioning.html

What is the maximum size of MySQL database table?

The effective maximum table size for MySQL databases is usuallydetermined by operating system constraints on file sizes, not by MySQLinternal limits. For up-to-date information operating system file sizelimits, refer to the documentation specific to your operating system.

来源https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html