R
ranageman
Guest
I'm having persistent problems with running over the "numfile" limit in my VPS (its set to 2100) - MySQL likes to eat about 1600 of these, and its a lightly loaded site.
I have tried various mysql options, reducing table_cache, max_connections etc, but cannot find the basic option to reduce the number of mysqld processes. This would at least place a limit on the open files. Right now there are 17 mysqld processes just waiting, keeping files open.
regards,
RM
I have tried various mysql options, reducing table_cache, max_connections etc, but cannot find the basic option to reduce the number of mysqld processes. This would at least place a limit on the open files. Right now there are 17 mysqld processes just waiting, keeping files open.
regards,
RM