# mysqladmin -h【ip地址】 -u【用户】 -p【密码】 status
Uptime: 281067 Threads: 102 Questions: 1122358 Slow queries: 0 Opens: 241 Flush tables: 1 Open tables: 202 Queries per second avg: 3.993
Thread:102就是当前时刻的连接数。
查看MySQL服务器的最大连接数:mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 3000 |
+-----------------+-------+
1 row in set (0.00 sec)
服务器响应的最大连接数:mysql> show global status like 'Max_used_connections';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 1811 |
+----------------------+-------+
1 row in set (0.01 sec)
比较理想的设置:Max_used_connections / max_connections * 100% ≈ 85%
最大连接数占上限连接数的85%左右,如果发现比例在10%以下,MySQL服务器连接上线就设置得过高了。