Achieve Comprehensive 24/7 MySQL and MariaDB Monitoring

SQL Diagnostic Manager for MySQL

Monitor in Real-time

Determine what is happening on MySQL or MariaDB servers in real-time. Get started with real-time monitoring in a single mouse click so that there is no need to enable logging manually. Fetch in real-time information on the top queries, tables, databases, users, hosts, SQL queries that are locked, SQL queries that are locking, and more. See what each MySQL or MariaDB server is up to at any point in time. Record monitoring sessions to later playback server activity for analysis.

Monitor Agentless

Avoid installing monitoring agents on monitored MySQL or MariaDB hosts since the architecture of the MySQL or MariaDB monitoring solution is agentless.

Monitor Queries

Monitor slow and long-locked SQL queries in real-time.

Monitor Security

Detect MySQL or MariaDB hacking attempts. Identify and fix MySQL or MariaDB security vulnerabilities.

Monitor Replication

Monitor replication including multiple sources. Register slaves automatically. Receive alerts when replications lag behind or when slaves stopped. See details of replication logs to troubleshoot replication. View color-coded states of MySQL or MariaDB servers.

Monitor Amazon RDS

Monitor file-based logs for Amazon RDS for MySQL, MariaDB, or Amazon RDS for Amazon Aurora.

Store Pseudo Server Log

Fetch SQL queries from MySQL or MariaDB servers using three methods: A ProcessList SQL query, the Performance Schema tables, and the MySQL Proxy application. Store all historical data in the embedded repository to find any database problems that occurred in the past.

Detect Issues Proactively

Keep a check on MySQL or MariaDB servers and provide timely alerts when something goes wrong with more than 600 monitors and advisors.

Alert Proactively

Display alerts on the Slack collaboration platform and the PagerDuty incident response platform. Integrate with the Syslog message logging protocol. Receive proactive alerts via email and Simple Network Management Protocol (SNMP) traps. Manage, accept, and dismiss events.

View Flexible Dashboard

Display unified views of all monitored MySQL or MariaDB servers. Display particular sets of charts and create multiple dashboards. Create custom sets of charts and monitor metrics specific to MySQL or MariaDB and operating systems for a single MySQL or MariaDB server and groups of MySQL or MariaDB servers with the dashboards. Quickly understand the complete security, availability, and performance picture of all monitored MySQL or MariaDB servers in a single location with the charts within the modern and intuitive user interface.

View Parameters and Metrics

Access all available metrics for MySQL or MariaDB server. Display a detailed display of server parameters and metrics. Display the metrics per server. Display data pertinent to each MySQL or MariaDB server for all monitored MySQL or MariaDB servers. Display some data as cumulative values accumulated over specified time frames and averaged over a time interval.

Analyze Executing Threads

Display the number of threads currently being executed by MySQL or MariaDB and the output of the “SHOW FULL PROCESSLIST” SQL query. View the process list with information on running SQL queries as per execution time.

Find and Analyze Problematic Queries

View the top 10 SQL queries across all MySQL or MariaDB servers. Identify and analyze problematic SQL queries. Find problematic SQL queries via “SHOW PROCESSLIST” snapshots at regular intervals, the MySQL Proxy application to collect profiling data, the Performance Schema tables, and by parsing the slow query logs and the general query logs. Export the resulting reports to comma-separated values (CSV) files.

Find Top 10 Queries across Servers

Uncover the top 10 problematic SQL queries across multiple MySQL or MariaDB servers to concentrate on areas that yield the highest value for efforts. Find the top 10 SQL queries across MySQL or MariaDB servers based on the total execution time to improve SQL query performance. Visualize critical alerts and warning alerts across MySQL or MariaDB servers to determine the cause of performance issues.

View Parsed Audit Logs

Display the parsed audit log maintained by MySQL Enterprise and MariaDB servers in clean tabular format. Access the audit log file the same way as the slow query log, the general query log, and the error log.

Compare and Track Configurations

Compare configurations of multiple MySQL or MariaDB servers side-by-side with all changes highlighted so that differences are visually discernible at a glance. Track changes to the MySQL or MariaDB server configuration files over a period. Ensure that MySQL or MariaDB servers are configured similarly when starting to notice performance issues in critical MySQL or MariaDB servers due to configuration inconsistency.

View Replication Topology

View the replication hierarchy of MySQL or MariaDB servers along with details of each replicated MySQL or MariaDB server. Switch from graphical to tabular replication view at any time to get a deep dive into the running MySQL or MariaDB servers. Display in the table of parameters the full status for all replication slaves. Display in the topology chart the replication graph and relationship of all monitored MySQL or MariaDB servers that are marked as master or slave, as well as slave status and master status while hovering over each server block. View the color-coded MySQL or MariaDB servers that represent the different states of the replication servers for stable, disconnected and non-synchronized MySQL or MariaDB servers.

Optimize Servers

Monitor MySQL or MariaDB servers with custom SQL queries. Monitor deadlocks. View information on disk usage of MySQL or MariaDB servers. Use advisors to improve MySQL or MariaDB servers. Analyze historical data and trends. Tune and optimize MySQL or MariaDB performance quickly. Analyze performance data for MySQL or MariaDB and operation systems collected over a period. Monitor error logs.

Manage Multiple Users

Filter access to specific MySQL or MariaDB servers for individual users. Specify different permissions for different users. Integrate the Lightweight Directory Access Protocol (LDAP) for Microsoft Active Directory and OpenLDAP.

Support Multiple Operating Systems

Run the monitoring application on 64-bit and 32-bit Microsoft Windows and 64-bit and 32-bit Linux. Install the monitoring application on Linux via RPM Package Manager (RPM) packages and non-RPM packages. Monitor MySQL or MariaDB on any platform including database-as-a-service.

Deploy with Flexible Licensing

Acquire the monitoring application with perpetual licensing. Enjoy organization-wide unlimited licensing at cost-effective prices. Do not be restricted by the number of installations locally and remotely by the licensing.

Setup Easily

Setup the monitoring application easily with the click of a button. Fetch the file paths of the SQL query logs automatically to start retrieving the contents of the log files. Avoid installing multiple web-MySQL or MariaDB servers and language runtimes.

Interact with Intuitive User Interface

Minimize the learning curve and errors with the modern and intuitive graphical user interface. View simple descriptions for all performance metrics which helps to learn about the internals of MySQL or MariaDB. Customize the user interface with JavaScript and the Object Model of the monitoring application. Compare an unlimited number of MySQL or MariaDB servers side-by-side on the real-time dashboard. Identify problems quickly with the enterprise dashboard..

Customize Dashboards and Charts

Customize dashboards and charts as per specific requirements for MySQL or MariaDB monitoring. Expand charts to identify sudden or unwarranted spiked and the SQL queries responsible for the spiked. View details on SQL queries to debug events that took place in the past. Identify database performance patterns and trends. View MySQL or MariaDB and system charts. Add multiple MySQL or MariaDB servers. Create custom dashboards. Zoom in on charts and view historical data.

Integrate via Application Programming Interface

Integrate the monitoring application with other software (such as command shells, scripts, and applications) via the application programming interface (API). Send Hypertext Transfer Protocol (HTTP) requests specifying the Uniform Resource Locator (URL) of the application with relevant parameters (for example, via the address bar of any web browser). Perform actions that are available in the graphical user interface (such as configuring the monitoring application). Manage the monitored MySQL or MariaDB servers, data collection, and alert settings.

No credit card required! Fully functional for 14 days

Buy Now

Includes first year of maintenance.
Volume discounts available.

Add to Cart

Need pricing options?

Request a quote for SMB or
multi-license discount pricing.

Request a Quote

Live Product Demo

See SQL Diagnostic Manager for MySQL in action with a seasoned pro.

Request a Demo

It helped us in optimizing and tracking mission critical data across 1700 customer sites and spread across 70 database servers.” Miguel Santos, Manager of Technical Operations, Moodlerooms (education technology company), USA.