SQL Diagnostic Manager for MySQL

What is SQL Diagnostic Manager for MySQL?

With SQL Diagnostic Manager for MySQL  you can monitorMySQL performance with more than 600 monitors

Agentless monitoring. Fully customizable. Optimize query performance in real time.

Real-time monitoring

Know what's happening right now on your servers.

Monitor each query in real time and identify what is causing a sudden or unwarranted increase in MySQL databases. Real-time monitoring helps you take corrective action and resolve key issues, even before they reach your end users.

Track SQL Diagnostic Manager for MySQL Configuration Changes

Find the cause of the performance issues.

Track all changes made to MySQL global variables using configuration management. You can track and compare changes to the configuration file and identify the reason for performance issues.

Monitor blocked and long-running queries

Reduce excessive CPU usage and query execution time.

Monitor blocked and long-running queries in real time. Receive notifications in mail traps or SNMP, Syslog, Slack, and Pagerduty for queries that take longer than a specified period of time to run. You also have the option to configure SQL Diagnostic Manager for MySQL to delete, notify, or notify and eliminate these queries.

RDS OS and file-based log monitoring

Monitor MySQL hosted as RDS/Aurora.

SQL Diagnostic Manager for MySQL shows the general query, slow query, and error logs in a single view, using the RD REST API. SQL DM for MySQL allows you to view RDS operating system metrics such as CPU utilization, RAM usage, etc. using the CloudWatch API.

Find the top 10 queries between servers

Quickly identify queries that cause performance issues.

SQL Diagnostic Manager for MySQL lets you find the top 10 queries between servers based on total execution time to help improve query performance in MySQL. View critical alerts and warning alerts on servers to find out the cause of performance issues.

Custom dashboard and charts

Identify database performance patterns and trends.

Customize the dashboard and charts to your MySQL monitoring requirements. You can expand a specific chart to identify a sudden/unwarranted increase and the queries responsible for the increase. SQL DM for MySQL provides details about the queries to debug an event that has occurred in the past.

MySQL Replication Topology View

Multi-master and multi-source replication.

View the replication hierarchy of the servers, along with the details of each replicated server, to ensure that the data is always up to date. At any time, you can switch from graphical to tabular replication view to get a deep dive into the running servers.

More than 600 best monitors and consultants

High availability, monitoring, alerts, and SNMP traps.

Get quick access to more than 600 monitors and consultants who continuously check the health status of your MySQL servers. SQL DM for MySQL will send alerts and traps in case a monitor crosses the threshold value set to critical and warning.

Sniffer-based query analyzer

Find the problematic MySQL queries.

SQL Diagnostic Manager for MySQL fetches queries from the MySQL server using three methods: Processlist, performance schema, and MySQL proxy. Sniffer stores all historical data in the embedded SQLite repository and helps you find any database issues that have occurred in the past.

Topics

Get the details of the MySQL queries that are executed.

Finding what keeps your servers busy is an important part of monitoring the database. SQL DM for MySQL shows the number of threads currently running on the MySQL server and the output of SHOW FULL PROCESSLIST.

System Requirements

Win7 x32, Win7 x64, WinServer, WinVista, WinVista x64, WinXP