Mysql “Too many connections” error in VICIDIAL Server



First check the maximum connections allowed.


Go to Mysql prompt and type the below command:
mysql > show variables like “max_connections”;


You should get following result:


| Variable_name   | Value |


| max_connections | 100   |



You can change the limit to higher value just by the below command without restarting the mysql ,but this will temporary until next reboot or restart of mysql server.
set global max_connections = 300;


For permanent effect:

Go to the /etc/my.cnf file and add the below lines and restart the mysql service.

max_connections = 200


Open Source Asterisk Hardware