On Wed, Jan 18, 2012 at 08:30:27AM +1100, Russell Coker wrote:
[thousands of connections in 'show processlist' like: 10.11.11.30:38784, 10.11.11.30:38785, 10.11.11.30:38786 and 10.11.11.40:42175, 10.11.11.40:42176, 10.11.11.40:42177 stuck in the login stage]
I've got a system running MySQL 4.1.22
any particular reason why you're running such an ancient version of mysql? 4.1 has been deprecated for years....and 4.1.22 isn't even the latest in the 4.1 series - 4.1.22 was released in 2006, and 4.1.25 was released in 2008.
Any suggestions for what I can do to investigate this?
look on hosts 10.11.11.30 and 10.11.11.40 and find out what's making all those connections. start with netstat and grep for the source port numbers...maybe something like 'netstat -tupan | grep :3878[456]' what version of the mysql client libs are on those hosts? craig -- craig sanders <cas@taz.net.au> BOFH excuse #130: new management