1. Home
  2. Technology
  3. MySQL
  4. Increase Max Connections Setting for MySQL

Increase Max Connections Setting for MySQL

In environments with multiple clusters, an HTTP 500 error may be thrown in Variphy by Apache Tomcat when trying to access CUCM clusters in the Call Analytics tab.

This may be caused by too many connections trying to access the MySQL database at once (the default number is set to 100). 

There is a ‘max_connections’ setting in MySQL which limits the number of connections that can be established.  This can affect Variphy and is typically identified by a SQL Error Code 1040 in the log files. After the 1040 error code you will see a line like this:

“Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Data source rejected establishment of connection,  message from server: “Too many connections”

To resolve this, try increase the max connections value for MySQL to 250.  

In MySQL Workbench or via cmd line, running the following SQL query will increase it to 250:

set global max_connections = 250;

This will change the running config of MySQL but not the startup settings (if the server is ever rebooted or the service is started). 

To change this startup setting, open the my.ini MySQL configuration file and within the [mysqld] section, modify or add/uncomment (if it doesn’t exist): 

max_connections=250

Updated on March 30, 2020

Related Articles