I have 2 servers:
- Server W(indows), a webserver that runs MS Server 2003. Server W is our main webserver, and runs Apache and PHP 5.
- Server U(buntu), that runs Ubuntu 10.04. Server U acts as a mail queuing server, running primarily a single C++ application and a single PHP script that interact with Server W's MySQL database.
I'm beginning to encounter massive CPU spikes on Server W, that brings its ability to properly host down. I'm talking 100% for 30 minutes, until the MySQL process is killed, or until the server is restarted.
When I use MySQL Query Browser to run a SHOW PROCESSLIST
, I can see that Server U is maintaining what I believe to be too long of a connection with the MySQL server. I've attached and highlighted the remote connection that seems to be offending. Unfortunately, I use the same MySQL user to connect with both the C++ app and the PHP script, so I'm not sure which one is the cause. I've temporarily disabled the mail server until I can pin down a cause.
I'm really stuck here, so if you have any kind of inkling in the slightest about what this could be, or, since it's such a generic question, of any additional information I can procure to expedite the debugging process.
You have the remote port in the processlist above (can't read it in the screenshot). With that knowledge go to the results of
netstat --program
under linux, which will give you the name and PID of the troublesome process, the remote port on Windows is the local port on the Linux side of things.