Re: Displaying the real thread PIDs.

2002-08-19 Thread Reid Sutherland (mysql)
Dan Nelson wrote: You cannot send signals to individual threads. Signals are delivered to the process as a whole rather than to a thread. The only way to kill a thread is from within the application itself. Mysql provides the kill id command for this. Thanks for your reply. What could

Fwd: Login command hanging - mysql 3.23.49

2002-08-12 Thread Reid Sutherland (mysql)
I hate to be so rude, but does anyone have an idea? If it's really an obvious answer, please smack me upside the head. Thanks, -reid Reid Sutherland (mysql) wrote: Hi, I'm using a program that makes many mysql connections. Now sometimes it leaves a hung mysql process. When I run

Login command hanging - mysql 3.23.49

2002-08-09 Thread Reid Sutherland (mysql)
Hi, I'm using a program that makes many mysql connections. Now sometimes it leaves a hung mysql process. When I run mysqladmin processlist, the process looks like this. (used my own formatting) pid,user,host,db,command,time,state,info

Re: restarting MySQL on OS X

2002-05-21 Thread Reid Sutherland (mysql)
Alex Pilson wrote: I was wondering if anyone knew the proper way to restart MySQL on OS X? I did mysqladmin -p shutdown then safe_mysqld...is this the same as if the machine started up? Not exactly the same. But for intents and purposes it does what you want. If you want to truly make it

Hung login mysql processes - unable to kill.

2002-05-20 Thread Reid Sutherland (mysql)
Hi everyone, I have a rather obscure problem with hung login connections in mysql. I've set the wait|interactive_timeout to 120 seconds, but it has no effect.\ If I attempt to `mysqladmin kill id`, the process is marked 'killed', but never goes away. Now I know the main problem is with