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

[Stephanie Sullivan]

On my servers I use my iptables firewall to prevent network connections
to/from mysql except from IP's that I explicitly allow. Seems to take care
of the issue nicely.

	Thanks,
		-Stephanie

> -----Original Message-----
> From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-
> bounces at blueonyx.it] On Behalf Of Jeff Jones
> Sent: Thursday, February 18, 2010 12:12 PM
> To: Blueonyx at blueonyx.it
> Subject: [BlueOnyx:03614] Tips for tracking down rogue mysql
> connection use?
> 
> 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
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx