Due to the way libnss-mysql and most other NSS modules is constructed, each program that needes to access user information will require a connection to the MySQL server. Apache, ssh, cron, etc., will all open connections. You can limit how long these stick around for by adjusting the MySQL server's wait_timeout option.
HTH,
-=| Ben
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
is there no way to limit the total of connections it opens, cause I am on the only person who ssh's into the system, and any system users are still in the passwd file, but for some reason, sometimes it will all of a sudden open up 60+ connections now.
Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
is there a way to keep libnss from opening so many sql connections to the database? it is opening like 20-30+ for no reason that I can see. Thanks.
Due to the way libnss-mysql and most other NSS modules is constructed, each program that needes to access user information will require a connection to the MySQL server. Apache, ssh, cron, etc., will all open connections. You can limit how long these stick around for by adjusting the MySQL server's wait_timeout option.
HTH,
-=| Ben
Thanks for the quick reply.
That makes sense to me. I will take a look at the timeout setting.
is there no way to limit the total of connections it opens, cause I am on the only person who ssh's into the system, and any system users are still in the passwd file, but for some reason, sometimes it will all of a sudden open up 60+ connections now.
Thanks.