MySQL monitoring FAQs

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 database only. 

What performance data is collected by Site24x7 for monitoring MySQL servers? 

Site24x7 collects data for the performance metrics listed in the document for supported metrics for MySQL servers and supported metrics for MySQL databases.

How do you collect performance metrics for MySQL monitoring? 

Performance metrics are collected by connecting to the MySQL server with the user credentials given by the user, which has limited read-only access to the performance_schema, information_schema, and sys databases.  

Does the Site24x7 agent access databases other than performance_schema, information_schema, and sys?

No, Site24x7 does not have any access to the databases except performance_schema, information_schema, and sys. 

How do you connect with the MySQL server?

Site24x7 uses pymysql python module to create a connection with the MySQL server with user credentials given in the terminal console. 

Do you keep the MySQL connection open?

No. Site24x7 creates a connection to the MySQL server for collecting performance metrics. Once the data collection is complete, the connection created will be closed. 

Do you store the MySQL user password directly?

No. Site24x7 encrypts the password given. The username and password are encrypted in the agent for security reasons. They will not be saved or stored in the Site24x7 app servers.

Related content:
  1. MySQL monitoring help document
  2. MySQL performance metrics monitored
  3. MySQL database metrics monitored

    • Related Articles

    • How to add/update the credentials of my MySQL database?

      To add the credentials, execute the below command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance To update the credentials, execute the below command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql ...

    • I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?

      By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...

    • 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 > ...

    • Can I add all the databases in my MySQL server as monitors?

      For now, Site24x7 has limited 200 databases for individual database monitoring. To check the feasibility of monitoring more databases, please contact support@site24x7.com. Check this page to learn more about how licensing is done for MySQL ...

    • 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 ...