finding source of mysql connections?
I run an h-sphere cluster. The web and Mysql servers are separate dedicated boxes.
The web server has been crashing very often due to high load. I have done some research and it looks like Apache is what is driving up the load. A netstat is showing that there is over 250 outbound connections to the MySQL server, this is what I believe is causing the problem. A customer who has a badly coded script which isn't closing out database connections properly.
Anyways, is there any way I can find out which site on the web server is causing the problem? Keep in mind that they are all running on a shared IP and it's running under Apache, so the processes are running as the httpd user.
Thanks in advance
