mysql 查询最大连接数以及当前连接数

查看mysql当前连接数

mysql> show status like 'Threads%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| Threads_cached    | 2     |
| Threads_connected | 1     |   ###目前打开的连接数  
| Threads_created   | 3     |   ###threads_created表示创建过的线程数
| Threads_running   | 2     |   ###这个数值指的是激活的连接数
+-------------------+-------+
4 rows in set (0.01 sec)

查看最大连接数

mysql> show variables like '%max_connections%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| max_connections        | 151   | ## 最大连接数
| mysqlx_max_connections | 100   |
+------------------------+-------+
2 rows in set, 1 warning (0.00 sec)