I am running Apache with mod_perl (Apache::DBI is off) with connections to
MySQL.
I'm finding that the number of connections used by perlhttpd seems to be
too high. I did this:
[root@sg3 root]# ps -A | grep mysqld | wc
88 353 2743
[root@sg3 root]# /etc/httpd/bin/perlhttpdctl restart
/etc/httpd/bin/perlhttpdctl restart: httpd restarted
[root@sg3 root]# ps -A | grep mysqld | wc
15 61 480
Restarting perlhttpd freed up 73 connections, but it shouldn't have been
using that many connections (perlhttpd has MaxClients set to 15).
I'm getting "Too many connections" error on the server about every 12
hours now; there seems to be a leak in the number of connections.
Can anyone suggest a solution to this?
BTW, I don't use $dbh->disconnect in my scripts. Is that a problem?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
