mysql> show full processlist;
+-----+--------+----------------------+------------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+--------+----------------------+------------+---------+------+-------+-----------------------+
| 4 | root | 203.247.29.70:4067 | sanhak2010 | Sleep | 16 | | NULL |
| 5 | root | 203.247.29.70:4068 | sanhak2010 | Sleep | 16 | | NULL |
| 6 | root | 203.247.29.70:4087 | sanhak2010 | Sleep | 449 | | NULL |
| 7 | root | 203.247.29.70:4088 | sanhak2010 | Sleep | 449 | | NULL |
| 304 | sanhak | localhost | NULL | Query | 0 | NULL | show full processlist |
| 305 | sanhak | 203.247.29.196:48259 | sanhak2010 | Sleep | 157 | | NULL |
+-----+--------+----------------------+------------+---------+------+-------+-----------------------+
6 rows in set (0.01 sec)
mysql> show status LIKE 'Threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 6 |
+-------------------+-------+
1 row in set (0.00 sec)
mysql> show status LIKE 'Threads_running';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| Threads_running | 1 |
+-----------------+-------+
1 row in set (0.00 sec)
프로세서 상태 조회
|
2010.08.02 13:39:38
|
2010.08.02 13:39:38
|
397
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2010.09.20
2010.09.06
2010.08.26
2010.08.07
2010.08.02
2010.08.02
2010.07.25
2010.07.25
2010.07.23
2010.07.01
2010.06.23