On Thu, 19 Jan 2012, Craig Sanders <cas@taz.net.au> wrote:
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.
The database server has been running that version mostly without problems for years. I tried to upgrade it a while ago but had some sort of password compatibility issue and haven't tried since. Upgrading a 24*7 database is a major PITA.
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]'
They are all legitimate connections for things such as looking up users who are receiving mail. The reason there are so many connections is simply because they aren't getting processed. Client processes were blocking on database queries and more processes are created.
what version of the mysql client libs are on those hosts?
Almost all the client systems are now running Debian/Squeeze with all the latest updates. There is one client system running RHEL4. Anyway I think I've solved this problem. I've edited /etc/hosts on the database server and added entries for every client system. It seems that the MySQL server may have been doing DNS lookups or something. It's been working well since I changed /etc/hosts. -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/