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 
at least.

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

Reply via email to