Database
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 ...
Why is the PostgreSQL individual database monitor shown as down even though that database is up in my instance?
If your PostgreSQL individual database monitor shows as down in Site24x7 but the database is active (up) in your instance, verify that if you have given the necessary permissions for the database user to access that specific database. Refer to our ...
I am unable to see any data for failed jobs in my database
If you are unable to see data for failed jobs or if there is a mismatch between the failed jobs data in the SQL performance monitor and the SQL insight monitor, check if you have granted the necessary permission. Data in the SQL performance monitor: ...
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 ...
I have an SQL Cluster that is Up and running. But the Insight monitor is indicating Down.
If the SQL Cluster Insight monitor is indicating DOWN even after giving credentials, check the following cases: Please check if you have given credentials in both the active and passive nodes. If the credentials have been updated only in the passive ...
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 > ...
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 ...
It says, "Failed to register MySQL instance." How to troubleshoot?
If you encounter the "Failed to register MySQL Monitoring" error message, check the following: Ensure the credentials provided are correct. To add or update the credential, check this article. Ensure the permissions are granted as shown here. ...
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 ...
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 ...
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 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 ...
Why is my MySQL monitor not discovered?
If your MySQL is not getting discovered, you cannot add your MySQL, you are unable to add MySQL server for monitoring, or unable to view your MySQL resources, try discovering your resources by navigating to Server > Server Monitor > Rediscover ...