AnsweredAssumed Answered

Have someone ever had problem from mysql Too many connection

Question asked by Autchara Chaiprom on Jun 20, 2017
Latest reply on Jun 22, 2017 by Autchara Chaiprom

Hi all,

 

I have some problem with connection between database and web app with error code:

Could not connect to DB server with options p:{db_server} as {db_name}. port : Too many connections

 

That made our system down.

I checked in database connection, a connection reach max_connection wait for a minute connections are lower and system came back again.

In stable time it using about 30-40 connections

but there is some time it come up with many connection from query below:

SELECT id, name, symbol, conversion_rate 
FROM currencies
WHERE status = 'Active' and deleted = 0

 

I increase this value from 128 to 151 but it not help, connection still reach max_connection.

I set persistent of config.php in sugar true/false for both values still the same problem.

 

Have someone ever had this problem before?

Any suggestion for me? 

 

Sugar Pro 7.8.2.0

Mysql ver 5.6.24

 

Thanks,

M

Outcomes