- Products
- Network Security
Next Generation FirewallNext-generation firewall for SMB, Enterprise, and Government
Security ServicesComprehensive security for your network security solution
Network Security ManagerModern Security Management for today’s security landscape
- Advanced Threat Protection
Capture ATPMulti-engine advanced threat detection
Capture Security applianceAdvanced Threat Protection for modern threat landscape
- Access Security
Cloud Edge Secure AccessDeploy Zero-Trust Security in minutes
Secure Mobile AccessRemote, best-in-class, secure access
Wireless Access PointsEasy to manage, fast and secure Wi-FI
SwitchesHigh-speed network switching for business connectivity
- Email Security
Email SecurityProtect against today’s advanced email threats
- Cloud Security
Cloud App SecurityVisibility and security for Cloud Apps
Cloud Firewall (NSv)Next-generation firewall capabilities in the cloud
- Endpoint Security
Capture ClientStop advanced threats and rollback the damage caused by malware
Content Filtering ClientControl access to unwanted and unsecure web content
- Product Widgets
- Product Menu Right Image
- Network Security
- Solutions
- Solutions Widgets
- Solutions Image Widgets
- Solutions Widgets
- Partners
- Partner Widgets
- Partners Image Widgets
- Partner Widgets
- Support
- Support Widget
- Support Image Widgets
- Support Widget
- Products
- Network Security
- Next Generation FirewallNext-generation firewall for SMB, Enterprise, and Government
- Security ServicesComprehensive security for your network security solution
- Network Security ManagerModern Security Management for today’s security landscape
- Advanced Threat Protection
- Capture ATPMulti-engine advanced threat detection
- Capture Security applianceAdvanced Threat Protection for modern threat landscape
- Access Security
- Cloud Edge Secure AccessDeploy Zero-Trust Security in minutes
- Secure Mobile AccessRemote, best-in-class, secure access
- Wireless Access PointsEasy to manage, fast and secure Wi-FI
- SwitchesHigh-speed network switching for business connectivity
- Email Security
- Email SecurityProtect against today’s advanced email threats
- Cloud Security
- Cloud App SecurityVisibility and security for Cloud Apps
- Cloud Firewall (NSv)Next-generation firewall capabilities in the cloud
- Endpoint Security
- Capture ClientStop advanced threats and rollback the damage caused by malware
- Content Filtering ClientControl access to unwanted and unsecure web content
- Product Widgets
- Product Menu Right Image
- Network Security
- Solutions
- Solutions Widgets
- Solutions Image Widgets
- Solutions Widgets
- Partners
- Partner Widgets
- Partners Image Widgets
- Partner Widgets
- Support
- Support Widget
- Support Image Widgets
- Support Widget
mysql show too many connections ( via a telnet test or in the logs )
03/26/2020 
1,049 People found this article helpful
43,220 Views
Description
Error message "too many connections" shows up:
------------------------------------------------------------------
- the connection to the mysql database , for example a Console-GMS Installation with the integrated mysql db show this error
- a telnet test to the consoleIP via "telnet consolegms-ip 3306" shows "too many connection"
- other example : Log-Message of the Agent which tries to connect to the Console-GMS shows "too many connection"
simple test via telnet and port 3306 to the GMS-IP which has the MySQL-DB:
Error message: "Too many connections"
- for example "telnet 123.123.123.123 3306" ( 123.123.123.123 can be a standalone or a console-Role or a DB-Role )
Cause
- there are too many requests coming in or some mysql-database connection are freezing and the number of connection increase
- one cause could be a high number of Agents, trying to connect to the Console-GMS IP ( which includes the mysql - db )
Resolution
- Solution:
* Find out where the MySQL DB is located ( typically the GMS-Console or a dedicated GMS-DB-Role ) . Access this GMS System
* Increase the Number of maximum allowed connection to the mysql-database in the techSupport.html site from 365 to 500 of this GMS
* Reboot the Windows-Server ( in a GMS software environement ). If it is a VA on a ESX(i) Server reboot the GMS VA
Follow this steps to reach the internal techSupport.html page:
---------------------------------------------------------------------
1) Login to the https:// your gms ip /sgms/login page
2) Change the url to https://youtgmsip/sgms/techSupport.html in the URL-Browser ( change it manually )
3) Click enter and you reach this site and then click on Accept
********************************************************************************************************
4) Now change the max connection value from 365 to a higher value ( like for example 500 )
********************************************************************************************************
5) Click update
6) Reboot the GMS ( either via the command line or you can restart the windows server or you can restart via the system interface )
Related Articles
- Can we make changes to a firewall config acquired on NSM directly through the firewall?
- Perform Restart of firewall from NSM.
- Requirement is to push cfs settings from one firewall to a group of Firewalls in NSM.
YES
NO