MySQL 프로세스 목록 확인 show processlist

MySQL process list
MySQL 프로세스 목록 확인

방법 1: mysqladmin

[root@zetawiki ~]# mysqladmin processlist -uroot -pP@ssw0rd
+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host      | db | Command | Time | State | Info             |
+----+------+-----------+----+---------+------+-------+------------------+
| 23 | root | localhost |    | Query   | 0    | init  | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+

방법 2: 쿼리

mysql> SHOW PROCESSLIST;
+----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host      | db   | Command | Time | State | Info             |
+----+------+-----------+------+---------+------+-------+------------------+
| 22 | root | localhost | NULL | Query   |    0 | init  | SHOW PROCESSLIST |
+----+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)

같이 보기

참고

https://mariadb.com/kb/en/mariadb/show-processlist/