What is the maximum number of MySQL data tables?

Is there a maximum number of data tables in a database? If so, how much is it? If I wanted to do a service that would provide PAAs to other users and allow users to freely create data tables, there would be a performance limit. For example, too many database files opened by a single server can cause noticeable performance degradation.

Reply content:

Is there a maximum number of data tables in a database? If so, how much is it? If I wanted to do a service that would provide PAAs to other users and allow users to freely create data tables, there would be a performance limit. For example, too many database files opened by a single server can cause noticeable performance degradation.

1. There should be an upper limit, for UNSIGNED INTEGER , 42亿 more.
2. File system support the number of simultaneous open files is very limited, generally at the K level.
3. Before the number of tables reached the theoretical limit, there was no machine in the world to support so many tables.
4. It is recommended that a user a library, which facilitates distributed deployment and migration.
5. If your business needs, there is a 09-year data, MySQL 50万张表 no significant impact on performance, single-table query time 0.3s around.

Http://dev.mysql.com/doc/refman/5.7/en/database-count-limit.html

MySQL has a no limit on the number of tables. The underlying file system may has a limit on the number of files that represent tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables.

