Limits on Number of Databases and Tables

问：mysql中，对database和table的数量有限制吗？

答：没有限制，不过会受到文件系统最大文件数限制。

 

原文：

C.10.2 Limits on Number of Databases and Tables

MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of directories.

MySQL has no limit on the number of tables. The underlying file system may have 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.