2016-03-30
현재 진행중인 쿼리 목록을 보고 싶다면 아래와 같이 SHOW PROCESSLIST를 통해 알 수 있다.
해당 프로세스를 끄는 방법은 KILL [해당ID]이다.

MariaDB [(none)]> show processlist;
+-------+------+-----------------+------+---------+------+-------+------------------+----------+
| Id    | User | Host            | db   | Command | Time | State | Info             | Progress |
+-------+------+-----------------+------+---------+------+-------+------------------+----------+
| 39997 | root | localhost:56914 | kca  | Sleep   |   62 |       | NULL             |    0.000 |
| 40542 | root | localhost:58182 | NULL | Query   |    0 | init  | show processlist |    0.000 |
+-------+------+-----------------+------+---------+------+-------+------------------+----------+
2 rows in set (0.00 sec)

MariaDB [(none)]> kill 39997;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show processlist;
+-------+------+-----------------+------+---------+------+-------+------------------+----------+
| Id    | User | Host            | db   | Command | Time | State | Info             | Progress |
+-------+------+-----------------+------+---------+------+-------+------------------+----------+
| 40542 | root | localhost:58182 | NULL | Query   |    0 | init  | show processlist |    0.000 |
+-------+------+-----------------+------+---------+------+-------+------------------+----------+
1 row in set (0.00 sec)