MySQL中的最大表数

本文介绍了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)