Back

如何查看mysql 当前的最大连接数? (check max connection numbers in mysql)

发布时间: 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