Re: How to interrupt MySQL interpreter output?
- Original Message - From: P.R.Karthik prk...@gmail.com And also make sure that you have the SUPER privilege to kill it. Note that even then, it might not die immediately (although it's status in show processlist will change to killed) if it's waiting for I/O. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to interrupt MySQL interpreter output?
From: Dotan Cohen dotanco...@gmail.com If I see that a query is taking a long time to finish, how can I interrupt the MySQL CLI interpreter? Ctrl-C does not work. Thanks. Does Ctrl-Z suspend the process? If so, you can then use the progression: kill -INT procnum; kill -QUIT procnum; kill -KILL procnum. Never do a kill -KILL until you've tried other ways of stopping it. I wouldn't even put it on the same command line like I showed above, as it may take some time for mysql(1) to clean up and shut down properly, and signals are asynchronous. Fire does not matter, earth and air and water do not matter. I do not matter. No word matters. But man forgets reality and remembers words. The more words he remembers, the cleverer do his fellows esteem him. He looks upon the great transformations of the world, but he does not see them as they were seen when man looked upon reality for the first time. Their names come to his lips and he smiles as he tastes them, thinking he knows them in the naming. -- Siddartha Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to interrupt MySQL interpreter output?
login into another session, check the thread id and kill it. ( Kill threadid.) On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen dotanco...@gmail.com wrote: If I see that a query is taking a long time to finish, how can I interrupt the MySQL CLI interpreter? Ctrl-C does not work. Thanks. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks Suresh Kuna MySQL DBA
Re: How to interrupt MySQL interpreter output?
And also make sure that you have the SUPER privilege to kill it. Regards, KarthiK.P.R On Fri, Jan 27, 2012 at 9:09 AM, Suresh Kuna sureshkumar...@gmail.comwrote: login into another session, check the thread id and kill it. ( Kill threadid.) On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen dotanco...@gmail.com wrote: If I see that a query is taking a long time to finish, how can I interrupt the MySQL CLI interpreter? Ctrl-C does not work. Thanks. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks Suresh Kuna MySQL DBA