Mysql connect Error: Too Many Connections

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Mysql connect Error: Too Many Connections

Postby pratikvicidial » Fri Jun 17, 2022 10:08 am

Hello Everyone

Hope all are doing well.

We are facing an issuee with the Mysql connect Error: Too Many Connections with our cluster setup with 1 DB and 6 Asterisk + Web server with agent around 100. DO we need to have some tunning at database server?


Below is the server spec

DB Server
Processor : AMD Epyc 7313 - 16c/ 32 t - 3GHz / 3.7GHz
Memory : 64 GB DDR4 ECC 3200MHz
Storage : 4 x 960 GB SSD SATA Hard RAID

Asterisk + Web servers
Processor : Intel Xeon-E 2388G - 8c/16t - 3.2GHz/4.6GHz
Memory : 32GB DDR4 ECC
Storage : 2x HDD SATA 4TB

Vicibox 9.0.2
VERSION: 2.14-833a
BUILD: 211106-1500
pratikvicidial
 
Posts: 18
Joined: Tue Mar 30, 2021 5:56 am

Re: Mysql connect Error: Too Many Connections

Postby williamconley » Fri Jun 17, 2022 5:21 pm

1) Thanks for including your installation and version information! 8-)

2) What do you have for the my.cnf max connections?
Code: Select all
cat /etc/my.cnf | grep max


4000 is a nice number for that on an enterprise system.

3) As this is obviously not "general discussion", but a Support request, I'll go ahead and move the thread to the proper board. :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 19960
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Mysql connect Error: Too Many Connections

Postby pratikvicidial » Tue Jun 21, 2022 12:40 am

Thanks for the response @williamconley
pratikvicidial
 
Posts: 18
Joined: Tue Mar 30, 2021 5:56 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 55 guests