mysql最大连接数

修改全局设置

set global max_connections=200;
或者修改my.cnf
    [mysqld]
set-variable=max_connections=250

 

查看最大连接数

mysql> show variables like '%max_connections%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 200   |
+-----------------+-------+

转载于:https://blog.51cto.com/fghjk/817554