MySQL is an open-source Relational Database Management System (RDBMS). It is almost universally included in web hosting packages. It has just over 15 percent of the global database market – only Microsoft SQL Server has more implementations with 18 percent of the market.
A MySQL database has three features that can be the cause of delivery issues. The first is the physical services that support the database. The next is the organization of the database implementation – tables that are incorrectly normalized and poorly indexed will never deliver query results quickly. The third MySQL influence on performance is the efficiency of the queries that it runs.
Here is our list of the ten best MySQL monitoring tools in 2020:
- SolarWinds Database Performance Monitor EDITOR’S CHOICE A monitoring system that has specific screens for MySQL monitoring plus host metrics monitoring and performance tuning functions. This is a cloud-based service. Start a 14-day free trial.
- Paessler PRTG MySQL Monitoring (FREE TRIAL) A MySQL monitor that is part of a comprehensive bundle of network, server, and application monitors. It runs on Windows Server.
- ManageEngine Applications Manager MySQL monitoring as part of a server and services monitoring package. It runs on Windows Server and Linux.
- Datadog APM An application performance monitor with specialist MySQL integrations.
- Dynatrace A specialist website monitoring system that includes performance monitoring and tuning for MySQL implementations.
- LogicMonitor MySQL Monitoring A cloud-based infrastructure monitor that includes specialized screens for MySQL monitoring.
- Atera A systems monitoring SaaS platform that is aimed at managed service providers and includes MySQL monitoring.
- dbWatch A specialized database monitoring and management system that includes procedures for MySQL monitoring. It runs on Windows, macOS, and Linux.
- Site24x7 A cloud-based infrastructure monitoring platform that includes servers, applications, and database monitoring with specialized routines for MySQL monitoring.
- MySQL Enterprise Monitor A comprehensive database monitoring and management service from the makers of MySQL. It runs on Windows, macOS, Linux, and BSD.
The best MySQL monitoring tools
MySQL is particularly important for web applications and so is critical to the profitable implementation of eCommerce websites. If MySQL hits performance issues, your entire business will tank. It is better to catch issues before they evolve into noticeable problems. This constant vigilance can only be implemented with automated monitoring systems.
There are many SQL analyzers and database scanners available but you really need a full MySQL monitoring system to ensure constant database availability at optimum performance. Don’t rely on methods that just focus on query responses – those checks are useful but not comprehensive. The best MySQL monitoring tools need to focus on the constant availability of services.
SolarWinds Database Performance Monitor is a SaaS system that can monitor a range of different DBMSs. The service is adapted by adding on integration to monitor a specific DBMS and there is one of these adaptations available to monitor MySQL databases.
The MySQL version of the Database Performance Monitor offers constant monitoring and also performance tuning and query development support. The monitor measures performance per query. The metrics that are tracked include latency, throughput, errors, warnings, index usage, and execution plans. The tool also examines the services that support the MySQL database, monitoring host statuses and database configuration issues, such as table sizes, memory usage, CPU utilization and availability, and I/O actions.
By covering both execution and configuration issues, the monitor is able to fully optimize the performance of any MySQL database anywhere. In total, the Database Performance Monitor tracks more than 10,000 metrics about each MySQL database implementation.
The SolarWinds Database Performance Monitor is a cloud-based service that is charged for by subscription. It is available for a 14-day free trial.
SolarWinds Database Performance Monitor is our top pick for a MySQL monitoring tool because it includes the supervision of physical supporting services, the database environment, query execution, and query development. This set of monitoring processes provides a complete MySQL monitoring service that will enable DBAs to keep MySQL databases available and functioning at optimal speed. As a cloud-based system, the console can be accessed from anywhere over the internet and any database anywhere in the world can be included in the service for monitoring. Start 14-day Free Trial: solarwinds.com/database-performance-monitor OS: Cloud-based
SolarWinds Database Performance Monitor is our top pick for a MySQL monitoring tool because it includes the supervision of physical supporting services, the database environment, query execution, and query development. This set of monitoring processes provides a complete MySQL monitoring service that will enable DBAs to keep MySQL databases available and functioning at optimal speed. As a cloud-based system, the console can be accessed from anywhere over the internet and any database anywhere in the world can be included in the service for monitoring.
Start 14-day Free Trial: solarwinds.com/database-performance-monitor
Paessler PRTG is a collection of infrastructure monitors covering networks, servers, and applications. Each monitor is called a “sensor” and keeps tabs on one aspect of a system. By combining sensors, PRTG gives a full view of all of the performance issues that could impact a MySQL database.
One of the methods that PRTG uses as part of its MySQL database monitoring procedures is to launch queries within the database to test response times. The execution of those queries not only measures the health of the database and its structures but also tests all of the factors that go into the running of the database, such as server and network issues.
By combining MySQL monitoring sensors with server and network monitors, the DBA is able to spot the real cause of performance problems which might not actually be the fault of the database itself.
PRTG is charged for by the number of sensors that the buyer wants to activate, with prices set in bands of sensor quantities. You can get a 30-day free trial of the system with unlimited sensors included.
ManageEngine Applications Manager monitors servers and applications. The long list of applications that the tool supports include database management systems. This list includes MySQL databases as well as those from Oracle, SQL Server, Informix, DB2, PostgreSQL, and Sybase.
The Applications Manager monitors all of the infrastructures that support MySQL databases, including factors such as CPU, memory, and disk capacity and utilization. The operations of the DBMS are also fully covered by the monitoring tool. Execution statistics such as memory utilization within the DBMS, disk interactions, processing transactions, and response times are also examined regularly. Each metric is shown live in the console and can be set to trigger alerts should performance thresholds be breached. This alerting system means that the DBA does not need to sit and watch all of the performance statistics all of the time.
Execution issues, such as coding errors and inefficient joins are highlighted by the Applications Manager. The tool can assess the table structure of a database against the SQL queries that run on them and recommend structural changes to objects and better query formats to improve performance. So, this tool is also a developer support system. Analysis of usage also provides recommendations on growth in tablespace size, enabling DBAs to plan capacity.
ManageEngine provides Applications Manager as software that installs on Windows Server and Linux. The package is available for a 30-day free trial.
Datadog is a cloud-based system monitoring and management service that is available in several modules. MySQL monitoring is implemented in the Datadog APM service. This is a general application monitor that can be adapted by vendor-specific plugins, which are called “integrations.” There is a MySQL integration available that tailors the database monitoring functions of the APM.
The monitor makes constant checks on a large number of database statuses, including tablespace utilization, buffer space, and disk activity. The MySQL monitoring tool also makes queries within the database to keep track of object quantities and table sizes. These tests are performed by a Datadog agent, which will install on Windows, macOS, and Linux. However, the processing of collected data is all performed on the Datadog servers.
The console for the MySQL monitoring tool is also hosted in the cloud, so it can be accessed from anywhere through any standard browser. The dashboard shows live statuses as attractive graphs and will also highlight conditions that have entered into a worrying performance zone.
Datadog APM is charged for by subscription per host per month or by the year. You can get a free trial of Datadog APM.
Dynatrace is best known as a web application management service. MySQL databases are widely used as part of website services and Dynatrace can be used to monitor any MySQL implementation – not just those that are part of websites.
A great feature of this MySQL monitoring tool is that it will seek out your database instances and map them before starting to monitor them. The monitoring service is constant, retrieving statistics to show live in the dashboard.
The metrics that the service measures include the standard checks on response times and resource usage. Additional performance analysis shows which applications use the database and how. Showing access to different objects and the types of transactions that occur. The tool can also analyze queries, producing recommendations for rewrites and remodeling of database objects.
The Dynatrace system is a cloud-based service, so it can be accessed from anywhere from any standard browser. The databases you look after can be on-site, in the cloud, or on the other side of the planet.
The service is charged on a subscription model and you can try it for free for 15 days.
LogicMonitor is a cloud-based infrastructure monitoring tool. It covers networks, servers, and applications. Among the applications that this system can monitor are databases. The specific access and monitoring execution routines that it implements are tailored by integrations. These are vendor-specific plugins to the system and there is one for MySQL.
The capabilities of the service extend to cloud servers and services and web performance. So, it would be of particular interest to those who run MySQL databases to support a website.
Data gathering is performed by an agent that needs to be installed on the database’s host. However, all processing is performed on the LogicMonitor cloud servers, which is also the host for the system dashboard.
The service is available in two plans, called Pro and Enterprise. Both plans include database monitoring as well as network and server monitoring. The plans both show live statuses and generate alerts when problems are detected. The system retains status readings for analysis – for one year with the Pro plan and for two years with the Enterprise plan. You can get a 14-day free trial of the LogicMonitor system.
Atera is a software package that supports Managed Service Providers (MSPs). The system is a SaaS service, so it includes the server that runs the software and all necessary storage space in with the price. The Atera RMM modules provide all of the systems that any IT service management company would need to monitor a client’s system, including MySQL monitoring tools and the ability to monitor other DBMSs.
Atera can backup and restore databases and watch over all relevant statuses, such as response times and resource usage. It is also able to monitor servers and network performance, so performance problems can accurately be traced to their sources.
Atera is priced per technician on a monthly subscription. You can test the system on a 30-day free trial.
If you don’t want to switch from your current infrastructure monitoring system, then a specialized database monitor, such as dbWatch would be a good solution.
The dbWatch monitoring service is able to monitor many databases simultaneously and they don’t all have to be from the same vendor. MySQL is among the list of DBMSs that dbWatch can monitor. Others include SQL Server, Oracle, Sybase, MariaDB, and Postgres.
The monitor is a cloud-based service and it can monitor on-premises, remote, or cloud-based databases. The system covers live statuses, showing graphs and statistics in the web-based console. It is also able to analyze performance over time to recommend changes in structures and plans for resource expansion.
There are three plan levels to dbWatch. The lowest of these, Essentials, doesn’t include database performance monitoring. The Professional, and Enterprise do include monitoring for MySQL plus other DBMSs. You can try out dbWatch Essentials risk-free on a 30-day free trial.
Site24x7 is a cloud-based infrastructure monitoring system that covers networks, servers, and applications. It also has specialized services for website performance monitoring. DBMSs are among the applications that Site24x7 can monitor and there is a special adaptation available for MySQL. The services of Site24x7 can be adapted by plugins to monitor specific products and this is how the MySQL monitoring tool gets loaded into the service.
The MySQL monitoring tool in Site24x7 will discover all databases on each host that you include in the monitoring service. It then documents each instance and starts live monitoring. These status checks extend to the host and services that support the databases. The MySQL monitoring agent can only be installed on Linux servers. However, it is able to monitor instances running on Windows over a network connection.
Site24x7 is charged for by subscription. The basic package is charged per host quantities with four plans including the monitoring of 10, 40, 100, or more servers. There is a long menu of add-ons that extend each plan.
You can use a free version to monitor up to five servers. Site24x7 is available for a 30-day free trial. Those who decide not to subscribe at the end of the trial period automatically get switched over to the free version.
The paid version of MySQL is called MySQL Enterprise edition and it includes MySQL Monitor.
This MySQL monitoring tool is able to detect and map cluster configurations and will monitor the statuses of supporting services and servers as well as the database instances themselves. It also traces replication topology and manages backups and restore functions. It watches the connections that applications use to access the MySQL database and reports on response times and resource usage.
MySQL Enterprise Monitor runs on Windows, macOS, Linux, and BSD Unix.
Choosing a MySQL monitoring tool
A good MySQL monitoring tool is able to make frequent tests on database response times, check on performance metrics, such as memory size and resource locks, watch the availability and speed of server resources, and analyze queries for improvement opportunities.
The main user of a MySQL monitoring tool is the Database Administrator (DBA). However, developers and service managers will also get important insights from a monitoring system. Many different roles in an organization will need to receive information about database performance for a range of reasons including SLA compliance proof and product developers wanting to know what capacity is available.
MySQL monitoring is not an optional task. It is essential to keep the business profitable.