mrherman Posted November 11, 2010 Share Posted November 11, 2010 OK, this has never occurred before -- just wondering what happened? I have this little desktop app (PHP and MySQL) that runs simple stats from an "in" table into an "out" table. The "in" table is large, so it is kinda slow...Probably my programming... Anyway, I run the PHP in a browser (FIREFOX) window. When I want the program to stop the process in order to debug a few things, I just hit the "STOP LOADING THIS PAGE" button in the browser. That has always worked to halt the program. This time, it wouldn't work. I clicked on "STOP LOADING... " button (as usual) and the browser said "stopped." But the program just kept on running. MySQL kept processing rows. I went to the XAMPP control panel and tried to stop Mysql. It said "stopped", but then said "busy" and kept on processing the data. I finally closed my IDE and about that time it finally stopped. It ran for about 20 mins. after I had clicked on the "STOP LOADING..." button and the browser stated "stopped" in the lower left. What happened? Why didn't it stop? Thanks! Quote Link to comment Share on other sites More sharing options...
mrherman Posted November 11, 2010 Author Share Posted November 11, 2010 See: http://stackoverflow.com/questions/2065396/how-to-stop-a-running-mysql-query and See http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html Quote Link to comment 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.