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

    • 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 ...
    • 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 ...
    • FAQs related to Windows Service monitoring

      After installing APM Insight Windows service monitoring agent , if you don't see data in the Site24x7 console, or if you are unable to add monitors, kindly follow the below given steps to troubleshoot. If few monitors are not getting added: Check for ...
    • Export SQL database details

      Please follow the below steps to fetch individual database reports from SQL servers: Log in to Site24x7. Navigate to Server > Microsoft SQL Server > click on the SQL server from which you want to export data. Go to Database, and scroll down to ...
    • Why is my MySQL plugin not getting added to Site24x7?

      Agent Requirements: The Site24x7 Linux monitoring agent version is above 15.0.0 The Site24x7 Linux server monitoring agent should be installed in the network or on the specific host where the MySQL instance is running. If you are running the plugin ...