Kill long running Mysql process

Login to Mysql console, type

$ mysql -uuser -ppassword;
$ show processlist;

it will produce following output:

mysql> show processlist;
+—–+——+—————–+——+———+——+——-+——————+
| Id | User | Host | db | Command | Time | State | Info |
+—–+——+—————–+——+———+——+——-+——————+
| 205 | root | localhost:61465 | NULL | Query | 0 | init | query |
+—–+——+—————–+——+———+——+——-+——————+
1 row in set (0.00 sec)

$ kill processID (here 205)

Advertisements

Published by

samrat131

Hello, I am a software developer from Bangladesh. I develop professional web sites/applications using LAMP(Linux, Apache, MySql, PHP) Stack. I have 7 years of professional working experience developing websites on WordPress, Magento, Laravel, Yii, Code Igniter. I have in depth knowledge on following language and tools, PHP, C, C++, Java, MySql, HTML(5), CSS(3), JavaScript, jQuery, Linux, Windows, Apache, Ngnix.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s