Is there a limit of the number of databases a single MySQL server can handle?
Answer
I'm unable to find any record of MySQL having a limit in the documentation.
If you're using MyISAM, you may run into a limit on the number of open file handles you can have as it uses several files per table. You can raise this using ulimit. InnoDB normally uses one file for all databases and two for database journal logs, but you still have one metadata file per table so this shouldn't be so much a problem unless you've configure InnoDB to do one file per table.
Regardless of open file handle limits, you'll find practical limits due to filesystem performance with many files in a directory structure, but we're talking several thousand in the same directory. If you get to this point, you're doing something very wrong.
No comments:
Post a Comment