Difference between revisions of "How to kill queries with mysql"
From Kolmisoft Wiki
Jump to navigationJump to search
(Created page with 'Instruction below describes how to easily kill unwanted queries with mysql. 1. Log in to your server over SSH. <br><br> 2. Log in to Mysql <br><br> 3. Use this query to show yo…') |
|||
| Line 18: | Line 18: | ||
In our example it would look like: | In our example it would look like: | ||
Kill 314102; or Kill 314155; | '''Kill 314102;''' or '''Kill 314155;''' | ||
5. If query is killed successfully, you will see message: | 5. If query is killed successfully, you will see message: | ||
Query OK | Query OK | ||
Revision as of 09:53, 21 May 2018
Instruction below describes how to easily kill unwanted queries with mysql.
1. Log in to your server over SSH.
2. Log in to Mysql
3. Use this query to show you the full process list:
SHOW FULL PROCESSLIST;
It will show you running queries in server. For example:
4. To kill query you should enter:
Kill <<query_id>>;
In our example it would look like:
Kill 314102; or Kill 314155;
5. If query is killed successfully, you will see message:
Query OK
