Mysql “Too many connections” error in VICIDIAL Server

Solution

Step1

First check the maximum connections allowed.

Step2

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   |

+—————–+——-+

Step3

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