发布时间: 2013-09-02 06:10:00
refer to http://www.linux4beginners.info/node/increase-max-connections-mysql-without-restart
mysql> select @@max_connections; mysql> select @@max_connections; +-------------------+ | @@max_connections | +-------------------+ | 100 | +-------------------+ 1 row in set (0.00 sec) max_connections is a GLOBAL variable. we can increase it on the fly without restarting mysqld service. To do so use following command. mysql> set global max_connections = 200; Query OK, 0 rows affected (0.00 sec)Back