SyntaxFix
Write A Post
Hire A Developer
Questions
Use mysqladmin to kill the runaway query:
mysqladmin
Run the following commands:
mysqladmin -uusername -ppassword pr
Then note down the process id.
mysqladmin -uusername -ppassword kill pid
The runaway query should no longer be consuming resources.