Why is the connection attempted count greater than the maximum connection count of my MySQL database?
The reason for the count of attempted connections being different from the maximum connections is because the Connections Attempted metric is different from the actual successful connections made.
- Connections Attempted comprises the number of connection attempts made to the MySQL server, including all the failed and successful connection attempts made to the MySQL database.
- Maximum Connections is the defined maximum number of connections allowed for the MySQL database.
- Threads Connected are the actual successful connections made to the MySQL database.
So, how can you track the exact connections made to your MySQL database?
You can achieve this by configuring Threads Connected under the threshold profile.
From your Site24x7 account, navigate to Database > the respective monitor > click the hamburger
icon > Edit.
Click the pencil
icon near Threshold and Availability and provide the required value under Threads Connected.
Click Save.
Related Articles
Troubleshoot the "pymysql module not found" error when installing the MySQL plugin
If you're encountering the pymysql module not found error, it likely means that the pymysql Python library is not installed on the server. pymysql is a Python package that provides a way to interact with MySQL databases using Python code and is used ...How do I monitor an Oracle database hosted in a Docker container in the same machine?
To monitor your Oracle Database hosted in a Docker container, follow these steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Execute the following command in your terminal and enter your Oracle Database instance's username ...Troubleshoot the Error 404 and Error 99 for RabbitMQ
When installing the RabbitMQ plugin, you may encounter the following errors: HTTP Error 404: Not Found: This error usually occurs when Site24x7's RabbitMQ monitoring plugin attempts to access the /api/overview page of RabbitMQ, but the resource ...Troubleshooting false positive alerts in monitoring
Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...Troubleshoot the Unauthorized user (Error 401) when installing Tomcat plugins
When installing Tomcat plugins, you may encounter the following error: Unauthorized user. Does not have permissions. HTTP Error 401: This error usually occurs when the user accessing the Tomcat Manager application does not have the necessary ...