Feb
20
Here is how to set some global variables in mySQL on the fly without having to restart the service.
To increase max_connections from 100 to 250 for example, run
mysql> set global max_connections=250;
Check using
mysql> show global variables;
Make sure to add it to /etc/my.cnf if you want the change to persist across restarts.
