Why is the connection attempted count greater than the maximum connection count of my MySQL database?

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.

  1. 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.
  2. Maximum Connections is the defined maximum number of connections allowed for the MySQL database.
  3. Threads Connected are the actual successful connections made to the MySQL database.

So, h
ow can you track the exact connections made to your MySQL database?

You can achieve this by configuring Threads Connected under the threshold profile.

  1. From your Site24x7 account, navigate to Database > the respective monitor > click the hamburger icon > Edit.

  2. Click the pencil  icon near Threshold and Availability and provide the required value under Threads Connected.

  3. ‚ÄčClick Save.

    • Related Articles

    • Troubleshoot connection errors in the MySQL plugin

      When configuring the MySQL plugin, you may encounter the following errors: Error : Connection Error - This error typically indicates that there is a problem establishing a connection to the database. Sometimes, this message is supplemented with an ...
    • MySQL monitoring FAQs

      Please find below some common FAQ's related to MySQL monitoring from Site24x7: Does Site24x7 need write permission to access databases? No. Site24x7 needs SELECT permission for performance_schema, information_schema, and EXECUTE permission for sys ...
    • How is MySQL added for monitoring in Site24x7?

      Site24x7 uses the server monitoring agent to monitor MySQL databases. To install the Site24x7 Server monitoring agent, follow the below steps: Log in to Site24x7. Install the Linux Server monitoring agent by navigating to Server > Server Monitor > ...
    • Troubleshoot the [Errno 111] Connection refused error for Oracle plugins

      When installing Oracle database monitoring plugins, you may encounter the following error: DPY-6005: cannot connect to database. [Errno 111] Connection refused This error indicates that there is an error connecting to the Oracle database server. Here ...
    • How to set thresholds for MySQL databases?

      From the Site24x7 web console, navigate to Database > MySQL > Instance Name to which you wish to add thresholds. Click the hamburger icon near the instance name and then click Edit. Navigate to Threshold and Availability under Configuration Profiles ...