1、查询数据库当前设置的最大连接数:
mysql> show variables like '%max_connections%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 1000 |
+-----------------+-------+
1 row in set (0.00 sec)
修改mysql最大连接数:
临时修改: set global max_connections=1000 或
在数据库配置文件进行永久修改:
[mysqld]
max_connections = 1000
2、查看服务器响应的最大连接数:
mysql> show status like '%Max_used_connections%';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 416 |
+----------------------+-------+
1 row in set (0.00 sec)
3、查看打开的连接数及并发数:
mysql> show status like 'Thread%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 14 |
| Threads_connected | 203 | #打开的文件数,跟show processlist结果相同
| Threads_created | 26930 | #创建过的线程数
| Threads_running | 2 | #激活的连接数,代表当前并发数
+-------------------+-------+
4 rows in set (0.00 sec)