현재 진행중인 쿼리 목록을 보고 싶다면 아래와 같이 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)