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 ...How to uninstall the Site24x7 Windows Server Monitoring Agent
Method 1: To uninstall the Site24x7 Windows Server Monitoring Agent, click the link below: https://staticdownloads.site24x7.com/server/Site24x7WindowsAgentUninstall.zip Unzip and execute the Uninstall.bat file in the Command Prompt as an ...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 ...Unable to add SQL insight monitor
If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...