MySQL 프로세스 목록 확인 show processlist

MySQL process list

MySQL 프로세스 목록 확인

1 방법 1: mysqladmin

Console

Copy

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

2 방법 2: 쿼리

Console

Copy

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)

3 같이 보기

• mysqladmin
• 동시 접속자 수 확인
• MySQL unauthenticated user 다수 발생
• MySQL SHOW
• MySQL show full processlist

4 참고

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