No Data for some of the metrics in MySQL 5.6/MariaDB 10.5

No Data for some of the metrics in MySQL 5.6/MariaDB 10.5

You might not be able to view the data for some of the metrics in MySQL or MariaDB monitors because the sys schema is not present in MariaDB version 10.5 and below and MySQL version 5.6 and below. As a result, Site24x7 MySQL individual database monitoring could not derive data for the metrics mentioned below:
  1. Throughput
  2. Latency
  3. Sequential Scan
  4. IO Reads & Writes
  5. Top Tables by Sequential Scan
  6. Most Time Consuming Queries
  7. Top Statements by Errors
These metrics will show No data in Site24x7. Apart from these metrics, all other metrics can be viewed in the Site24x7 web console. 
If you are still having issues, zip all the agent logs and send the file to support@site24x7.com. 

Customers also who read this KB also searched for:
Why do I see limited metrics in MySQL 5.6/MariaDB 10.5?

    • Related Articles

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

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

    • My MySQL monitor shows "no data."

      Troubleshooting tips when no data is shown in MySQL monitor: Please provide the credentials to the Site24x7 server monitoring agent using the following command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance Ensure the ...

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