Pada Thu, 5 Sep 2002 09:39:33 -0700
"James Kelty" <jamesk@stripped> menulis :
> mysql,query
>
>
> Hello,
>
> Maybe I'm an idiot, but I can't find any documentation on how to stop
> running queries interactively. The only thing I can come up with is to stop
> and restart the server. I don't want to do that. Basically, if a user does
> something stupid, and sparks off a query that is hogging resources, I'd like
> to be able to kill that query so everyone else can get on with life. How is
> this, if it can be done, accomplished?
from mysql :
mysql> show processlist;
mysql> kill <thread_id>;
or from shell :
shell> mysqladmin -p processlist
shell> mysqladmin -p kill <thread_id>
or use mytop or mtop ;-)
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 76 days, Queries : 359.985 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com
