Azu Posted May 22, 2007 Share Posted May 22, 2007 I entered a query wrong and it has been stuck for like an hour when it should only have taken a second or two. Is there a way that I can stop the query besides turning off the MySQL server and then turning it back on again? I entered in the query in SQLyog, if that matters. update `DB2`.`data` set `info`=(select `info` from `DB1`.`data` where `id`=`db2`.`data`.`id` limit 1); Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/ Share on other sites More sharing options...
binindex Posted May 22, 2007 Share Posted May 22, 2007 do a showprocesslist and then kill the thread it is running on. Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/#findComment-258727 Share on other sites More sharing options...
Azu Posted May 23, 2007 Author Share Posted May 23, 2007 Okay thanks ^^ and could you please tell me how to do that? :S Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/#findComment-259545 Share on other sites More sharing options...
fenway Posted May 23, 2007 Share Posted May 23, 2007 Take a look here. Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/#findComment-260148 Share on other sites More sharing options...
Azu Posted May 23, 2007 Author Share Posted May 23, 2007 Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/#findComment-260247 Share on other sites More sharing options...
shoz Posted May 23, 2007 Share Posted May 23, 2007 Put a semicolon at the end of each statement SHOW PROCESSLIST; KILL .... ; Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/#findComment-260349 Share on other sites More sharing options...
Azu Posted May 25, 2007 Author Share Posted May 25, 2007 Thank you! That fixed it Quote Link to comment https://forums.phpfreaks.com/topic/52424-solved-cancel-a-frozen-query/#findComment-261425 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.