MySQL Too Many Connections

Products

• CA API Gateway

Issue/Introduction

There is an error when trying to connect to the MySQL Gateway database: ERROR 1040 (HY000): Too many connections

In the MySQL configuration, the max_connections is set to 100 connections.

mysql> show variables like '%connect%' ;

+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
|  max_connections|100    |
+------------------+-------+
1 row in set (0.00 sec)

Is there a recomended value for this configuration?

Environment

API Gateway 10.1
External Mysql 8.0.X

 

Resolution

In the Gateway 10.1 appliance, the max_connections is set to 2625. It's recommended to set your max_connections to 2625.

You can add/edit this parameter to your /etc/my.cnf file:

max_connections=2625

OR 

You can update the database directly:

set global max_connections = 2625;

Both options require the MySQL service to be restarted.