查看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)