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); 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. 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 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. 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 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 .... ; 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 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
Archived
This topic is now archived and is closed to further replies.