On 24/09/12 15:03, emijrp wrote:
Can you kill them?
I always connect to login.toolserver.org http://login.toolserver.org. How do I change to rosemary?
rosemary is a sql server.
You'd do something like this:
$ mysql -h rosemary
mysql> show full processlist; +-----------+------------+-----------------------------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----------+------------+-----------------------------+------+---------+------+-------+-----------------------+ | 142886093 | platonides | willow.toolserver.org:62886 | NULL | Query | 0 | NULL | show full processlist | +-----------+------------+-----------------------------+------+---------+------+-------+-----------------------+ 1 row in set (0.00 sec)
mysql> kill 142886093;
Of course, you would have some problems doing it when you can't even connect to the server :)
I had the same problem on Saturday with s2-rr, even after killing all php.fcgi instances on the webservers (the ones from which those 15 connections could have originated), the server wasn't allowing me to connect.
While we're blaming the sql servers, I had a script failing this night with «Lost connection to MySQL server at 'reading initial communication packet', system error: 0 (sql-s3-rr.toolserver.org)» but it is working to now.
Regards