In transactional databases deadlocks are a classic problem, but these deadlocks are not too dangerous unless they are so frequent that you cannot run certain transactions at all. To trace…
SQL DM for MySQL query sniffer is a functionality that records a pseudo server log and stores it in the SQL DM for MySQL embedded database. With Sniffer enabled, SQL DM for…
This works exactly the same way as the MySQL Error log and MySQL Query Log. On enabling audit log monitoring, SQL DM for MySQL fetches the path from the server and…
SQL DM for MySQL retrieves (completely or partially) the General query log and the Slow query log from the MySQL servers it connects to, and analyzes them. Here, we see…
The MySQL error log is quintessential in determining the health of the server. You can Enable error log monitoring to allow SQL DM for MySQL to keep an eye on your MySQL…
Use this option to Auto register all the Galera nodes of your cluster with SQL DM for MySQL. The MySQL and the SSH details of the nodes are assumed to…
If you want to collect data from the server, you need to select Enable Data Collection, so SQL DM for MySQL collects and stores various MySQL and OS metrics. Define the…
System Metrics (applicable for Linux based systems) In the event that you would like SQL DM for MySQL to use SSH when communicating with this server, you can configure it…
To use the SQL DM for MySQL Notification alert functionality to send you alerts about a MySQL server you need to configure the different Notification channels from Settings -> Notification &…
Tags are used for grouping servers. When you have few servers it is easy to keep track of them but, it is increasingly difficult to keep track of servers when…
