Set MySQL Connection Count On The Fly

Occasionally you'll run into a situation in which the connection count you've configured for MySQL is too low. This often happens on load balanced applications. You can use the following commands to view and set the connection limit on the fly:

mysql> select @@global.max_connections;
+--------------------------+
| @@global.max_connections |
+--------------------------+
|                     1000 |
+--------------------------+
1 row in set (0.00 sec)

mysql> set @@global.max_connections = 3000;
Query OK, 0 rows affected (0.00 sec)

original url : https://boxpanel.blueboxgrp.com/public/the_vault/index.php/Set_MySQL_Connection_Count_On_The_Fly