mysqladmin -uroot -przxidc2012 processlist //查看数据库连接
mysql> show processlist
-> ;+----+-----------------+---------------------+-------+---------+-------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+---------------------+-------+---------+-------+------------------------+------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 18130 | Waiting on empty queue | NULL |
| 8 | root | localhost | nsdpf | Query | 0 | NULL | show processlist |
| 39 | root | 192.168.31.106:1432 | nsdpf | Sleep | 95 | | NULL |
+----+-----------------+---------------------+-------+---------+-------+------------------------+------------------+
mysql> show full processlist; //会显示连接的状态 ,如果是inode好像不会,有个status locked
+-----+-----------------+----------------------+-------+---------+--------+------------------------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-----------------+----------------------+-------+---------+--------+------------------------+-----------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 509640 | Waiting on empty queue | NULL |
| 187 | root | localhost | nsdpf | Query | 0 | NULL | show full processlist |
| 318 | root | 192.168.31.105:49174 | nsdpf | Sleep | 1072 | | NULL |
| 319 | root | 192.168.31.105:49175 | nsdpf | Sleep | 102 | | NULL |
| 320 | root | 192.168.31.105:49176 | nsdpf | Sleep | 102 | | NULL |
| 321 | root | 192.168.31.105:49177 | nsdpf | Sleep | 102 | | NULL |
| 322 | root | 192.168.31.105:49178 | nsdpf | Sleep | 102 | | NULL |
| 323 | root | 192.168.31.105:49179 | nsdpf | Sleep | 100 | | NULL |
| 324 | root | 192.168.31.105:49180 | nsdpf | Sleep | 100 | | NULL |
| 325 | root | 192.168.31.105:49181 | nsdpf | Sleep | 100 | | NULL |
| 326 | root | 192.168.31.105:49182 | nsdpf | Sleep | 102 | | NULL |
| 327 | root | 192.168.31.105:49183 | nsdpf | Sleep | 102 | | NULL |
| 328 | root | 192.168.31.105:49184 | nsdpf | Sleep | 102 | | NULL |
| 386 | root | 192.168.31.105:58079 | nsdpf | Sleep | 9 | | NULL |
+-----+-----------------+----------------------+-------+---------+--------+------------------------+-----------------------+
14 rows in set (0.00 sec)