Top 5 MySQL Monitoring tools 2020

We all love MySQL and want to make sure that our apps work seamlessly. However, there are hopes and there is reality.
So in this article, we have decided to list the top 5 MySQL monitoring tools.

#1: EverSQL

EverSQL provides a different type of MySQL monitoring solution, mainly focused on tracking and automatically optimizing slow SQL queries, based on trends learned from analyzing over 350,000 real-world SQL queries.
While it is not focused on I/O and CPU monitoring, it uses AI to analyze SQL queries, it rewrites the queries and provides automatic optimizing insights as if MySQL experts analyzed your queries.

Optimize your database, auto-magically.
Click to start, for free.

Pros:

  • Automatically rewrites SQL queries and optimizes them
  • Recommends missing indexes automatically
  • Provides insights such as workload analysis and new query load discovery
  • Educate users on best practices with real examples
  • Find redundant indexes
  • Analyze slow query logs and optimize queries in bulks
  • Aggregate query executions by fingerprints for easier prioritization
  • Integrates with 3rd party monitoring tools
  • Advanced query filtering
  • Agentless option
  • Provides top insights within minutes
  • Support for both cloud-based and on-premise platforms

Price: 14-days free trial. Starts at $25 / Month

#2: Percona Monitoring and Management (PMM)

a free and open-source platform for managing and monitoring MySQL and MongoDB performance, and provides time-based analysis to ensure that your data works as efficiently as possible.

Pros:

  • Group like-systems together based on Cluster, Replication Set, Geographic Area, custom labels, and more.
  • Easy set-up
  • Query analytics
  • Point-in-time visibility and historical trending
  • Review fleets of servers and drill down to Clusters
  • Integration with MongoDB query profiler
  • Administrative API
  • Based on Grafana and Prometheus
  • Find slowest queries

Price: Free and open-source platform

#3: VividCortex

Database performance monitoring and optimization for open source and NoSQL databases. VividCortex is a database workload and a performance monitoring suite. VividCortex was recently acquired by Solarwinds who develop additional tools for IT managers.

Optimize your database, auto-magically.
Click to start, for free.

Pros:

  • SaaS based solution
  • Lightweight agents with multiple configurations
  • Compare performance before and after new code deployment
  • Find slowest queries
  • Monitor Database health
  • Create customized dashboards
  • Adaptive fault detection helps find small interruptions to server or service availability.
  • Advanced Query filtering
  • Disk latency monitoring

Price: 14-days free trial. Starts at $2,840

#4: MySQL Enterprise Monitoring

MySQL Enterprise Monitor provides real-time visibility into the performance and availability of all your MySQL databases. It is a part of the paid version of MySQL Enterprise and comes together with additional tools.

Pros:

    • Monitors connections, queries, raw access
    • Track availability
    • Monitor Host and instance
    • Visualize replication topology
    • Auto-discovers and visualize cluster topology
    • Track Backup and Replication status
    • Aggregate Query executions and row access
    • Shows Query Latency Trend
    • Disk monitoring for capacity planning
    • No agent required
    • Role-based access control
    • SLA monitoring
    • Query Response Time Index
    • Auto-discovers replication topology
    • Full NDB cluster support (Auto-Discovery, Visualization, and grouping of NDB processes)
    • User statistics report
  • Best Practices list

Price: Only available as a part of MySQL Enterprise/Cluster Editions, Starts at $5,000

#5: Idera’s SQL Diagnostic Manager for MySQL

SQL DM for MySQL is a monitor and advisor application for MySQL database administrations. It provides you with tools to manage more database servers, to tune your current database infrastructure, and to aid you in finding and fixing problems with your database applications before they develop into more serious issues or costly outages.

Pros:

  • Monitor in real-time for corrective action and issues resolution
  • Track and compare all changes to MySQL or MariaDB configuration files
  • Agentless
  • Diskspace analysis to assist disk cleanup
  • Create customized dashboards
  • Replication monitoring
  • Audit logs option
  • Monitor, alert, and kill locked or long-running SQL queries
  • Monitor Amazon RDS, MariaDB, or Amazon Aurora, Azure Database, Google Cloud SQL, and Oracle Cloud Service

Price: 14-day trial, stars at $399 per server

Optimize your database, auto-magically.
Click to start, for free.