Hello.
MySQL was developed to hold huge count of users and databases.
In addition to:
http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html
You may read:
http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html
(There is also some tips about the magic number 1024).
"Andre
Everything has a limit. Sometimes it's just ridiculously high that it
might as well be infinity. This is not the case with open files. I'm
not sure if MySQL has it's own limit or if it is constrained by the
operating system, like it is with file size. Max open files is a
function of the OS, not
Hi.
I have database structure of about 45 tables, and a separate database for
each of the 100+ users.
Everything has been working nicely for quite some time.
When I wrote a function that looped through all the DBs and ran some
queries, MySQL hung and I got "too many open files" in my .err-file.
(