[BlueOnyx:03614] Tips for tracking down rogue mysql connection use?

[Jeff Jones]

Hi all,

It never rains, then it pours! 

Had a situation today where sites on one BX box suddenly reported their MySQL as being down. A quick look into BX admin showed me that MySQL was indeed up - however on going to PHPMyAdmin - I get a red 'Too Many Connections' error.

First time this has happened. I checked inbound traffic, nothing special - and not really much load on the server.

My first initial theory is that perhaps someone / something ran a a DB script externally, perhaps a DOS or something.

So I'm after any clues on how best to figure out exactly what is using MySQL connections if it happens again. 

The MySQL log doesn't tell me much, and the Netstat shows me the connections, but not what is actually using them.

Any ideas?

Cheers,

Jeff