Bug #53453 Docs: please list the maximum number of tables/databases
Submitted: 6 May 2010 2:51 Modified: 3 Jul 2011 1:06
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[6 May 2010 2:51] Roel Van de Paar 
Description:
Could we have the maximum number of tables and databases in the manual somewhere? I have no idea about MyISAM maximum's, but from a slide set by Heikki and Calvin here are the maximums for InnoDB:

- Maximum number of tables - 4G (I believe this far exceeds your need of 51,200)
- Maximum size of a table - 32TB
- Maximum columns per table 1000
- Maximum tablespace size 64TB

How to repeat:
See manual

Suggested fix:
List details
[6 May 2010 3:00] Roel Van de Paar 
Please ignore the "(I believe this far exceeds your need of 51,200)" remark.
[26 Aug 2010 10:12] Sergey Vojtovich 
Since there is no dictionary, MyISAM (MySQL either) doesn't set any restriction on number of passive MyISAM tables/databases. But underlying file system may have limit on number of files and directories.

I believe I seen some relevant remark in the manual, but failed to find it again.
[3 Jul 2011 1:07] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

http://dev.mysql.com/doc/refman/5.5/en/database-count-limit.html