MySQL中的最大表数 [英] Maximum Number of Tables in MySQL

问题描述

MySQL最多可以处理多少个表?

What is the maximum number of tables that MySQL can handle?

推荐答案

您在问这个问题的事实可能表明您没有采取最佳实践方法来解决问题.

The fact that you are asking this question is probably an indicator that you are not taking a best practice approach to your problem.

您可能想解释为什么需要创建许多表，以查看是否会收到有关如何解决此问题的更好建议.

You may want to explain why you need to create many tables, in order to see if you will receive better suggestions on how to tackle this issue.

但是，对于MySQL数据库中的表数没有服务器限制，但是由于每个MyISAM表都有关联的文件，因此任何操作系统对允许的文件数限制都会产生影响. InnoDB表，索引等存储在单个表空间中，最多可容纳20亿张表. (源)

However, there are no server limits on the number of tables in a MySQL database, but since each MyISAM table has associated files, then any OS limits on the number of files allowed will have an effect. InnoDB tables, indexes, etc, are stored in a single tablespace, with a maximum of two billion tables. (Source)

这篇关于MySQL中的最大表数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！