How to kill mysql process
Today I executed a largy query in MySQL that made MySQL process run at 100% cpu. Naturally this affected the performance of the server machine where MySQL is hosted. Here’s how to fix this MySQL performance problem:
- log in to MySQL console
- type show processlist;
- the system will show you the list of processes running on MySQL
- locate the process you think should be killed and note its process ID (Id column)
- type kill ID where ID is the suspected process ID
