I need a little direction for troubleshooting a problem
I'm having with PHP and MySQL.
Twice recently my little homebrew PHP/MySQL content
management system has essentially crashed when MySQL
starts returning a 1040 error: "Too many connections."
Restarting MySQL fixes things ... for a little while
Currently I am trying to manage the situation by
monitoring the process count and restarting mysqld
whenever the count gets high, but I need to get a
better handle on what is going on.
I'm running Apache 1.3.27, PHP 4.1.2, and MySQL
Most of my connections are made with PHP's
My understanding is that each Apache/PHP process will
reuse a connection made with mysql_pconnect.
If so -- and assuming one db connection per http
response -- I would expect there to be a
correspondance between the number of Apache processes
and mysqld processes.
This isn't the case. One day after restarting MySQL and
httpd, Apache has 21 processes running and mysqld has
62 processes. Is this an indication of a problem or am
I barking up the wrong tree?
Any other suggestions for troubleshooting?
Thanks in advance,
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php