MySQL 프로세스 목록 확인 show processlist

MySQL process list

MySQL 프로세스 목록 확인

1 방법

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

2 같이 보기

• mysqladmin