search cancel

CA API Management: Seeing a high number of MySQL connections under your Gateway ping service

book

Article ID: 10844

calendar_today

Updated On:

Products

STARTER PACK-7 CA Rapid App Security CA API Gateway

Issue/Introduction

A high number of MySQL connections may be seen when reviewing the output of the Gateway (ssg) ping service



You may notice a high number of connections (two million connections plus) under the output of the ping service:


PingService1.png

Environment

You will see this in most versions of Gateway 8.4 and above where you have MySQL installed. Trying to see the status of MySQL database from the ping service from Https:\\ServerName:8443/ssg/ping

Resolution

This connection represents the lifetime connections to the server and it is not an indication that there is a problem on your server. It simply keeps track of all connections made to the MySQL from Day one.

 

mysql> show status like '%onn%';

+--------------------------+---------+

| Variable_name            | Value   |

+--------------------------+---------+

| Aborted_connects         | 2636873 |

| Connections              | 2707763 |

| Max_used_connections     | 610     |

| Ssl_client_connects      | 0       |

| Ssl_connect_renegotiates | 0       |

| Ssl_finished_connects    | 0       |

| Threads_connected        | 14      |

+--------------------------+---------+

7 rows in set (0.00 sec)

 

Additional Information

Refer to this MySQL link for additional information on the connection

https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Connections

 

Attachments

1558701347651000010844_sktwi1f5rjvs16pft.png get_app