1、查看连接数
show status like 'Threads%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 58 |
| Threads_connected | 57 | ###这个数值指的是打开的连接数
| Threads_created | 3676 |
| Threads_running | 4 | ###这个数值指的是激活的连接数,这个数值一般远低于connected数值
+-------------------+-------+
Threads_connected 跟show processlist结果相同,表示当前连接数。准确的来说,Threads_running是代表当前并发数
2、查询数据库当前设置的最大连接数
show variables like '%max_connections%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 1000 |
+-----------------+-------+
3、查询连接有关的参数
show variables like '%connect%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| character_set_connection | utf8|
| collation_connection | utf8_general_ci|
| connect_timeout | 10|
| disconnect_on_expired_password| ON|
| init_connect| |
| max_connect_errors | 100|
| max_connections | 400|
| max_user_connections | |
| performance_schema_session_connect_attrs_size| 512|
+-----------------+-------+
4、
show processlist;
5、设置最大连接数
set GLOBAL max_connections=400;
或:
修改mysql配置文件my.cnf,在[mysqld]段中添加或修改max_connections值: