Query throughputĬount of executed statements (sent by client) For instance, some of the features in the MySQL Workbench, which is detailed in Part 2 of this series, are not compatible with currently available versions of MariaDB.Īmazon RDS users should check out our specialized monitoring guides for MySQL on RDS and for the MySQL-compatible Amazon Aurora. Most of the metrics and monitoring strategies outlined here also apply to MySQL-compatible technologies such MariaDB and Percona Server, with some notable differences.
Differences between those versions will be pointed out along the way.
#Mysql enterprise monitoring collaboration series
Some of the monitoring strategies discussed in this series are specific to MySQL versions 5.6 and 5.7. Compatibility between versions and technologies This article references metric terminology introduced in our Monitoring 101 series, which provides a framework for metric collection and alerting.
#Mysql enterprise monitoring collaboration how to
In the second part of this series we’ll show you how to access and collect all of these metrics. MySQL users can access hundreds of metrics from the database, so in this article we’ll focus on a handful of key metrics that will enable you to gain real-time insight into your database’s health and performance. In order to keep your database running smoothly, you can actively monitor metrics covering four areas of performance and resource utilization: If your database is running slowly, or failing to serve queries for any reason, every part of your stack that depends on that database will suffer performance problems as well. Initially released in 1995, MySQL has since spawned high-profile forks for competing technologies such as MariaDB and Percona. Owned by Oracle, MySQL is available in the freely downloadable Community Edition as well as in commercial editions with added features and support. MySQL is the most popular open source relational database server in the world. Part 2 is about collecting metrics from MySQL, and Part 3 explains how to monitor MySQL using Datadog. This post is part 1 of a 3-part series about MySQL monitoring.