Datasheet : Monitor MySQL Performance with SQL Diagnostic Manager for MySQL

The monitoring of MySQL and MariaDB environments is much more straightforward with quality monitoring applications. The proper monitoring applications can let database administrators know when something may be going wrong. SQL Diagnostic Manager for MySQL is a monitor and advisor tool for MySQL and MariaDB. It provides database administrators and system administrators with the right metrics to manage and optimize applications during development and production. It provides the tools to manage many MySQL and MariaDB servers, to tune the database infrastructure, and to aid in finding and fixing problems with database applications before they develop into more serious issues or costly outages.

Performance monitoring

  1. Start monitoring fast

    Rapidly install and configure all the components needed for monitoring MySQL servers with the unique architecture and low footprint of SDM for MySQL.

  2. Deploy agentless monitoring

    Avoid installing monitoring agents on each MySQL server. Instead, use a standard MySQL connection for monitoring. Collect all monitoring data by using remote connections.

  3. Monitor in real-time

    Know what is happening to MySQL servers without delay. Get vital data with a single click of a mouse button. There is no need to enable slow query logs and general query logs.

Query performance

  1. Find problematic SQL queries

    Locate troublesome SQL queries via five different methods to pinpoint the problematic SQL queries to overcome the lack of advanced native tools for profiling SQL queries.

  2. Track and analyze SQL queries

    Continuously monitor SQL queries in real-time. Send notifications for long-running SQL queries. Specify an option to kill such queries automatically.

  3. Quickly find problematic queries

    Find the top 10 problematic queries across servers based on the total execution time. Visualize critical and warning alerts across servers to find the cause of performance issues.

Customization

  1. Customize advisor rules

    Customize the acceptable thresholds for each MySQL server for each of the included advisor rules. Add new monitors, change existing monitors, and disable pre-defined monitors.

  2. Create custom SQL objects

    Monitor MySQL servers by creating custom SQL objects instead of by writing SQL queries. Track and reference the custom SQL objects via an array of MySQL rows.

  3. Customize dashboards and charts

    Customize the dashboard and charts as per specific MySQL monitoring requirements. Expand a particular chart to identify spikes and the responsible queries.

Enterprise management

  1. Scale up to large environments

    Monitor over 500 MySQL servers (even at collection intervals of 1 second) effortlessly with a single installation of SDM for MySQL, according to internal benchmark reports.

  2. Monitor hybrid environments

    Avoid learning new tools by using the same performance monitoring tool for on-premises databases, databases on cloud virtual machines, and managed cloud databases.

  3. Compare servers

    View real-time charts of all critical metrics in the enterprise dashboard. See a merged view of how many MySQL servers are performing with a single instance of SDM for MySQL.

Alerting

  1. Receive proactive alerts

    Violations of advisor rules trigger events for all monitors. The events provide expert advice on the reported problem. Prevent alerts for insignificant events with delayed notifications.

  2. Monitor deadlocks

    Monitor MySQL servers for deadlocks. Send notifications of deadlock alerts. Besides detecting deadlocks, view data on the latest deadlock found.

  3. Monitor error logs

    Monitor MySQL error logs. Send notifications over simple mail transfer protocol (SMTP) and simple network management protocol (SNMP) for error events that require attention.

Diagnostics

  1. View and understand trends

    Analyze historical data to see sudden changes in performance parameters and problems immediately. Visually analyze a metric across MySQL servers at various points in time.

  2. Analyze threads

    Display the number of threads that MySQL is executing. View the process list with information on running SQL queries as per execution time.

  3. Analyze space usage

    Display the size of data indexes of the databases with the disk space usage analyzer. Display a graphical chart to locate the largest databases quickly. Drill down to the table level.

Cloud

  1. Install on cloud virtual machines

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

  2. Monitor databases on cloud virtual machines

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

  3. Monitor managed cloud databases

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

Best practices

  1. Fix problems proactively

    Examine the configuration and security of MySQL servers automatically, find problems and tuning opportunities, and access specific corrective actions with over 600 monitors.

  2. Follow best practices

    Monitor MySQL servers with confidence with a set of best practices from the advisor rules. Receive notifications with specific instructions on how to proactively address the problems.

  3. Automate advisor rules

    Automate the advisor rules for unattended, around the clock operations. Minimize human errors, improve overall productivity, and lower the total cost of managing MySQL servers.

Environment overview

  1. Display dashboard overview

    Instantly understand the complete security, availability, and performance of all MySQL servers in a single place, all from a modern and intuitive web interface.

  2. Monitor server configuration

    Compare the configurations of MySQL servers side-by-side with highlighted changes. Track changes to the configuration files of MySQL servers to manage the settings and their impact.

  3. View replication topology

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

Security

  1. Detect security problems

    Detect MySQL hacking attempts. Also, determine and fix security vulnerabilities to prevent data breaches.

  2. Alert on security issues

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

  3. Manage multiple-user access

    Set up users with limited access to specified servers and settings. Specify the type of user, role, and allowed and disallowed actions, tags, and tabs. Prevent unauthorized activities.

Download This Datasheet Start a FREE Trial of SQL Diagnostic Manager for MySQL
Share This
Contact IDERA:
+1 (713) 523-4433