Wednesday, July 12, 2017

[MySQL][Resolved] MySQL kill running query

I get a strange situation that the application keep inserting records (over 10,000,000 records LOL) to MySQL database, it looks cause by an endless loop. After I close the broswer queries are skill keep inserting records, and then i restart broswer and clean all broswer's history it still keep going on.

And stackoverflow save me again.

Firstly, use this command to know all process id
show processlist;

Mark down this holy shit process id 1296, and then run then command , text in red is the process id:


kill 1296;

Reference

https://stackoverflow.com/questions/3787651/how-can-i-stop-a-running-mysql-query
https://stackoverflow.com/questions/1903838/how-do-i-kill-all-the-processes-in-mysql-show-processlist

No comments :

Post a Comment