My MySQL server has run up against the OS's (RHEL 4) limit on maximum
number of open files. This is causing queries to terminate badly, user
connections refused, and it's generally a bad situation.
I've been reading about how it's possible to raise this limit by setting
'ulimit -n' to some higher number. It's currently at 1024. The only
thing this machine does is MySQL, so there are no concerns about other
users, etc. Before I make any changes, though, I was hoping someone
might help me figure out a reasonable way to increase this number. This
is new territory, so I'm wanting to tread cautiously.
FYI : /proc/sys/fs/file-max (which I understand to be the limit on all
files opened by all processes) is 562523. What other information is
pertinent?
thanks,
alex
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)