hello
i have a strange problem.
freebsd 6.0 amd64, dual xeon
mysql 5.0.18
huge conf, myisam and heap tables.
around 1000 query/sec, without any problem in the last 2 week.
the problem is:
the stuff is running perfectly with a load of 0.8-1.0
it was correct, but 20 hours before something happened.
one query arrived, done it's job, and after it the connection doesn't turn
to closed.
the query is still in the processlist, state sleep, running time is crazy,
and the machine's load is jumped to 1.8-2.2 in the moment when this
process was started in mysql.
i tired to kill it, but (and this is the most strange) process's state
turned to killed, but it's already in the process list and nothing happen.
i tired to kill it in console and with mysqladmin, but nothing helps.
i think a restart will help it but it's not the solution for me. i want to
know why and how happened this, and how i can kill this damn process.
and i'm not allowed to restart the mysql daemon. it must be another way.
anybody know any solution?
thanks a lot.
sixday
ps: sorry for my shit english
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
