一、命令mysqladmin
1、查看当前所有连接的详细:
mysqladmin -uroot -p -h127.0.0.1 processlist
2、只查看当前连接数(Threads就是连接数.):
mysqladmin -uroot -p -h127.0.0.1 status
3、查看当前所有连接的详细资料:
[zabbix@test160 bin]$ mysqladmin -uroot -p123456 processlist
Warning: Using a password on the command line interface can be insecure.
+--------+--------+-----------+--------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+--------+-----------+--------+---------+------+-------+------------------+
| 3 | zabbix | localhost | zabbix | Sleep | 73 | | |
| 8 | zabbix | localhost | zabbix | Sleep | 1 | | |
| 9 | zabbix | localhost | zabbix | Sleep | 15 | | |
| 10 | zabbix | localhost | zabbix | Sleep | 2 | | |
| 11 | zabbix | localh