Red Hat Bugzilla – Bug 459497
not possible to have more than 31999 directories under /var/lib/mysql
Last modified: 2013-07-02 23:19:08 EDT
Description of problem:
If the /var/lib/mysql directory contain more than 31999 files/directories/databases that new database creation is not possible.
This is not possible even for root.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. have more than 31999 databases
2. try to create new database
The mysql server crashes
The database is created
This is important for web hotels, ISP etc.
fedora.polarhome.com has more than 70k accounts and more than 50k mysql databases created (usually one user one database)
Unfortunately, it is needed to be removed not used databases (subdirectories) under /var/lib/mysql in order to create new databases.
When the number of entries in /var/lib/mysql fall below 31999, the new database creation is possible.
This sounds like it's due to the ext3 limit on number of subdirectories in a directory. Use another filesystem, or rethink whether you really need so many databases.