查看mysql 的连接数：

来源：互联网发布：mac 杀毒编辑：程序博客网时间：2024/04/30 09:27

$ mysqladmin -uroot -p -h192.168.2.*** status

mysqladmin -uroot -hlocalhost -proot processlist
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------------+------+---------+------+-------+------------------+
| 2 | root | 192.168.2.*:62283 | test | Sleep | 961 | | |
| 3 | root | 192.168.2.*:62284 | | Sleep | 876 | | |
| 5 | root | 192.168.1.***:55688 | test | Sleep | 168 | | |
| 24 | root | 192.168.1.***:55805 | test | Sleep | 550 | | |
| 25 | root | 192.168.1.***:55807 | test | Sleep | 0 | | |
| 26 | root | 192.168.1.***:55806 | test | Sleep | 550 | | |
| 27 | root | 192.168.1.***:55808 | test | Sleep | 550 | | |
| 28 | root | 192.168.1.***:55815 | test | Sleep | 0 | | |
| 29 | root | 192.168.1.***:55817 | test | Sleep | 0 | | |
| 30 | root | 192.168.1.***:55818 | test | Sleep | 0 | | |
| 31 | root | 192.168.1.***:55819 | test | Sleep | 0 | | |
| 32 | root | 192.168.1.***:55820 | test | Sleep | 0 | | |
| 36 | root | 192.168.1.***:56695 | test | Sleep | 0 | | |
| 37 | root | 192.168.1.***:56696 | test | Sleep | 0 | | |
| 38 | root | 192.168.1.***:56697 | test | Sleep | 0 | | |
| 39 | root | 192.168.1.***:56698 | test | Sleep | 0 | | |
| 40 | root | 192.168.1.***:56699 | test | Sleep | 0 | | |
| 41 | root | ceshiserver234:26721 | | Query | 0 | init | show processlist |
+----+------+----------------------+------+------
查看详细的状态。

0 0