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): mysql-5.0.51a-1.fc9.i386 mysql-devel-5.0.51a-1.fc9.i386 mysqlclient10-3.23.58-9.2.1.i386 mysql-libs-5.0.51a-1.fc9.i386 mysql-server-5.0.51a-1.fc9.i386 mod_auth_mysql-3.0.0-6.i386 How reproducible: Always. Steps to Reproduce: 1. have more than 31999 databases 2. try to create new database Actual results: The mysql server crashes Expected results: The database is created Additional info: 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.