MySQL 5.0 Reference Manual :: E Restrictions and Limits :: E.7 Limits in MySQL :: E.7.2 Limits on Number of Databases and Tables

Section Navigation [Toggle]

E.7 Limits in MySQL
E.7.1 Limits of Joins
E.7.2 Limits on Number of Databases and Tables
E.7.3 Limits on Table Size
E.7.4 Limits on Table Column Count and Row Size
E.7.5 Limits Imposed by .frm File Structure
E.7.6 Windows Platform Limitations

E.7.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 databases. The underlying file system may have a limit on the number of tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables.

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents