Performance Monitoring

• Monitor in real-time

  Get started with real-time monitoring in a single mouse click and avoid enabling logging manually. See what MySQL and MariaDB servers are up to anytime.

• Deploy agentless

  Avoid installing monitoring agents on monitored servers as the architecture of the monitoring solution is agentless.

• Monitor queries

  Monitor slow, top slowest, and long-locked SQL queries in real-time. View details of SQL queries to investigate the cause of problems.

• Detect security problems

  Detect MySQL and MariaDB hacking attempts. Also, identify and fix security vulnerabilities.

• Monitor replication

  Monitor replication including multiple sources. Register slaves automatically. Receive alerts when replications lag or when slaves stopped.

• Monitor cloud databases

  Monitor managed cloud databases including Amazon RDS for MySQL/MariaDB/Aurora, Microsoft Azure Database for MySQL, Google Cloud SQL for MySQL, and Oracle MySQL Cloud Service.

• Store pseudo server logs

  Fetch SQL queries from MySQL and MariaDB servers using three methods.

• Browse history

  Record monitoring sessions by storing all historical data in the embedded repository. Later play back server activity to investigate any problems that occurred in the past.

Alerting

• Detect problems proactively

  Keep a check on servers in real-time by providing timely alerts when something goes wrong.

• Alert based on best practices

  Choose from over 600 predefined monitors and advisors based on industry best practices. Modify configuration settings for greater flexibility.

• Set metric thresholds

  Set thresholds for each metric via JavaScript to identify warning and critical alerts for different database environments.

• Notify effectively

  Display alerts on Slack and PagerDuty. Integrate with Syslog. Receive alerts via email and Simple Network Management Protocol traps. Manage, accept, and dismiss events.

• Alert on security issues

  Alert on hacking attempts and security risks via dedicated metrics to notify relevant staff immediately.

• Alert on locks and deadlocks

  Detect locks, blocks, and deadlocks by monitoring the relevant metrics as compared to their thresholds.

• Alert on disk problems

  Observe metrics exceeding thresholds to detect issues with disk space and disk availability.

Diagnostics and Analytics

• View flexible dashboard

  Display unified views of all monitored servers in a single location. Create multiple dashboards and customized sets of charts.

• Display parameters and metrics

  Display any available settings and metrics for MySQL and MariaDB. Display cumulative and average values for data.

• Analyze threads

  Display the number of threads currently being executed by MySQL and MariaDB. View the process list with information on running SQL queries as per execution time.

• Find and analyze problematic queries

  Find problematic SQL queries via three different methods. Monitor custom SQL queries for application-specific monitoring.

• Find top queries across servers

  Uncover the top problematic SQL queries across multiple servers based on the total execution time.

• View parsed audit logs

  Display the parsed audit log in a tabular format. Access the audit log file like the slow query log, the general query log, and the error log.

• View replication topology

  View the replication hierarchy of servers along with details of each replicated server. Switch from graphical to tabular to deep dive into the running servers.

• Optimize servers

  Monitor deadlocks, disk usage, and error logs. Analyze historical data and trends. Use advisors to improve servers. Tune and optimize performance quickly.

Enterprise Management

• Manage multiple users

  Specify different access permissions for different users. Integrate the Lightweight Directory Access Protocol for Microsoft Active Directory and OpenLDAP.

• Support different operating systems

  Run SQL Diagnostic Manager on Microsoft Windows and Linux. Monitor MySQL and MariaDB in the cloud including database-as-a-service.

• Deploy with flexible licensing

  Acquire the monitoring application with perpetual licensing. Do not be restricted by the number of installations locally and remotely by the licensing.

• Set up quickly

  Configure SQL Diagnostic Manager easily with a single mouse click. Fetch the file paths of the SQL query logs automatically to start retrieving the contents of the log files.

• Customize dashboards and charts

  Customize charts and dashboards as per specific requirements for different environments.

• Integrate with other systems

  Integrate SQL Diagnostic Manager with other software (such as command shells, scripts, and applications) via the application programming interface.

• Compare and track configurations

  Compare configurations of multiple servers side-by-side with all changes highlighted. Track changes to server configuration files.

• Deploy for hybrid cloud

  Deploy SQL Diagnostic Manager to monitor on-premise databases, databases on cloud virtual machines, and managed cloud databases.

Cloud

• Install on cloud virtual machines

  Run SQL Diagnostic Manager for MySQL on cloud virtual machines with Microsoft Windows and Linux – such as Amazon Elastic Compute Cloud (EC2) and Microsoft Azure Virtual Machines (VMs).

• Access mapped cloud drives

  SQL Diagnostic Manager for MySQL can access cloud storage that is mapped as network drives or removable drives on Windows. For example, map to Amazon Simple Storage Service (S3) and Microsoft Azure Blob Storage.

• Monitor MySQL on cloud virtual machines

  Monitor instances of MySQL running on cloud virtual machines – such as Amazon EC2 and Microsoft Azure VMs.

• Monitor managed MySQL cloud databases

  Monitor the managed MySQL cloud databases Amazon RDS for MySQL/MariaDB/Aurora, Microsoft Azure Database for MySQL, Google Cloud SQL for MySQL, and Oracle MySQL Cloud Service.

• Monitor hybrid environments with a single tool

  Avoid learning new tools by using the same performance monitoring tool for MySQL on-premise on physical and virtual machines, in the private, public, and government cloud on virtual machines, and in the public and government cloud as managed databases.