How to kill a hanging MySQL Client Process?

First you need to identify the Loading MySQL client process using the mysql processlist command.

# mysqladmin -u root processlist
+—–+————–+———–+————–+———+——+——-+——————+
| Id  | User         | Host      | db           | Command | Time | State | Info             |
+—–+————–+———–+————–+———+——+——-+——————+
| 95  | eximstats    | localhost | eximstats    | Sleep   | 842  |       |                  |
| 117 | leechprotect | localhost | leechprotect | Sleep   | 563  |       |                  |
| 125 | root         | localhost |              | Query   | 0    |       | show processlist |
+—–+————–+———–+————–+———+——+——-+——————+

Now, You can use kill command and enter the process_id as shown below. If you want to kill multiple process you can pass comma separated process id’s.

# mysqladmin -u root kill 117

# mysqladmin -u root processlist
+—–+————–+———–+————–+———+——+——-+——————+
| Id  | User         | Host      | db           | Command | Time | State | Info             |
+—–+————–+———–+————–+———+——+——-+——————+
| 95  | eximstats    | localhost | eximstats    | Sleep   | 842  |       |                  |
| 125 | root         | localhost |              | Query   | 0    |       | show processlist |
+—–+————–+———–+————–+———+——+——-+——————+

 

Bookmark the permalink.

Comments are closed.