RE: Aborting a greedy querry from the command line
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort everything entirely even with threading and what not. Maybe a MySQL person can step in here and throw in an explanation :). It might me odd but it's true; and annoying. Have to restart the daemon otherwise the server will continue to chew CPU and disk doing the query. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborting a greedy querry from the command line
On Tuesday 20 June 2006 08:23, Ciprian Vizitiu wrote: On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort everything entirely even with threading and what not. Maybe a MySQL person can step in here and throw in an explanation :). It might me odd but it's true; and annoying. Have to restart the daemon otherwise the server will continue to chew CPU and disk doing the query. You can execute a kill from the mysql command prompt to remove the query. No need to take the entire server down. Scanned by mailCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Aborting a greedy querry from the command line
Quoting Ciprian Vizitiu [EMAIL PROTECTED]: On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort everything entirely even with threading and what not. Maybe a MySQL person can step in here and throw in an explanation :). It might me odd but it's true; and annoying. Have to restart the daemon otherwise the server will continue to chew CPU and disk doing the query. Why not just kill the query (process) in mysqld? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Aborting a greedy querry from the command line
Hi Scott, mysqladmin can issue a kill from the command line. You will have to issue a mysqladmin -u etc. etc. processlist to get the process id from mysql and then you can issue a mysqladmin -u etc. etc. kill mysql process id Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 June 2006 8:32 AM To: mysql@lists.mysql.com Subject: Aborting a greedy querry from the command line Sometimes I will issue something, slip of the fingers, and mysql will chew on it for hours, the best I can do is control-z to get out of it and log back in. But, I just learned these processes are still running, and I have to go in and kill them by hand. Is there any easy way to abort from the command line and have it really stop that query? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborting a greedy querry from the command line
On Monday 19 June 2006 04:02 pm, Scott Haneda wrote: Sometimes I will issue something, slip of the fingers, and mysql will chew on it for hours, the best I can do is control-z to get out of it and log back in. But, I just learned these processes are still running, and I have to go in and kill them by hand. CTRL+Z simply puts a process in sleep mode so it can be woken up later on. CTRL+C will kill the MySQL process (thus killing the query). While I don't like that method, it's the only one I've found so far. Is there any easy way to abort from the command line and have it really stop that query? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- Chris White PHP Programmer/DB Overclocker Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Aborting a greedy querry from the command line
Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 June 2006 8:37 AM To: mysql@lists.mysql.com Subject: Re: Aborting a greedy querry from the command line On Monday 19 June 2006 04:02 pm, Scott Haneda wrote: Sometimes I will issue something, slip of the fingers, and mysql will chew on it for hours, the best I can do is control-z to get out of it and log back in. But, I just learned these processes are still running, and I have to go in and kill them by hand. CTRL+Z simply puts a process in sleep mode so it can be woken up later on. CTRL+C will kill the MySQL process (thus killing the query). While I don't like that method, it's the only one I've found so far. Is there any easy way to abort from the command line and have it really stop that query? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- Chris White PHP Programmer/DB Overclocker Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborting a greedy querry from the command line
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort everything entirely even with threading and what not. Maybe a MySQL person can step in here and throw in an explanation :). Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -- Chris White PHP Programmer/DBreak My Mind Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborting a greedy querry from the command line
In the last episode (Jun 19), Chris White said: On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort everything entirely even with threading and what not. Maybe a MySQL person can step in here and throw in an explanation :). It aborts the client. The query is still running on the server and won't know that the client is gone until it tries to return the resultset. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]