On Mon, Apr 29, 2002 at 10:23:25PM -0500, Dave Losen wrote: > Greetings, > > I'm new to the list and apologize if this question has already been > answered. > > I'm trying to figure out how to make a thread die. From the > processlist command of mysqladmin I get back a listing of > unauthenticated user that I want to drop from their connection > status. > > I issue the ./mysqladmin kill [ID] command.
So far so good. > the mysqladmin processlist command tells me that the the thread is > "KILLED" but the connection still exists. > > MY QUESTION : > > Is there a variable or defined setting that I can configure to tell > mysqld when to drop the connection/thread ? Nope. You can only kill it. If you don't want connections from that host, you should block access using the GRANT/REVOKE commands. > The online manual provides the following information > > " When you do a KILL, a thread specific kill flag is set for the thread. > In most cases it may take some time for the thread to die as the kill > flag is only checked at specific intervals." Right. That's how it works. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 84 days, processed 2,187,101,564 queries (300/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
