any way to kill/disconnect a unix domain socket?
I have described my issue in detail here: http://forums.mysql.com/read.php?24,...977#msg-297977
basically, I am having a mysql server which keeps piling up on it's unix domain socket connections. here's a small example of netstat as it looks now (count about 80-100 connections paired with httpd): Code:
Active UNIX domain sockets (servers and established) I have setup a crontab script to kill and restart the mysql server when it cannot connect and it runs every 5 min. however this only lead to mysql being down sooner rather than later because in many cases just kill -9 and then service start mysql does not do the job (it's either part of the same issue of mysql or another issue). basically I need to manually kill mysqld instances a bunch of times until it's ok, OR, if that doesn't work, stop everything that is using mysql, wait a few minutes, and then start mysql. so I ditched that script and now I am manually restarting mysql server every ~ 24 hours. so basically it's a pain. if I were to kill the stray connections however, I will not have to bother every day with restarting mysql. I hope. so, any ideas? thanks. |
I just made a test and:
service apache restart ** this took a little while to stop killall -29 mysqld ** waited about 10 seconds or so ** tried to connect, failed killall -9 mysqld ** connected successfully this appears to be a good workaround. if nothing comes up in the following days, I will keep testing this scenario and see if it works all/most of the time. |
between the killall -29 and killall -9 there is definitely some timing thing. I had to issue a few killall -9 's before I was able to reconnect (this was with all command executed with about 2-4 seconds between them.
though this appears to be a workaround, I would very much like to get some ideas to test in an attempt to actually fix this. just in case it matters (though it didn't matter with mysql 4.x), my server is an old PIII with 256 MB ram and 512 MB swap, RH 9 in text mode only. as I said, this server behaved very good before the upgrade so unless mysql 5.1.x comes with some high minimum requirements, this shouldn't be the cause. |
All times are GMT -5. The time now is 06:19 PM. |