MySQL Database Service

MySQL Database(DB) Service is a widely used relational database management system. MySQL DB offers a freely downloadable Community Edition and commercial editions with added features and support.

Use the Observe MySQL app to get out-of-the-box visibility into the overall health of your MySQL DB instances. This app helps you answer questions such as the following:

  • What is the throughput volume? Does it seem normal?

  • Is the database query performance healthy? Are there high latency or error rates?

  • Are the database instances reaching their connection limits? Are they returning connection errors?

The MySQL app installs the following datasets by default:

  • Error Logs

  • General Logs

  • Instance

  • Log Events

  • Metrics

  • Slow Query Logs

  • Telegraf Events

Viewing MySQL DB performance in Observe

After installing the app, view the health of your MySQL DB instances by going to the Instance dataset in Observe. This dataset models the instances of MySQL DB running in your environment, whether you manage the instance on a host or through a managed service on a cloud provider. This dataset offers GraphLinks to the following resources:

  • Metrics

  • General Logs

  • Slow Query Logs

  • Error Logs

From this resource, you can filter to any number of MySQL DB instances and use the default dashboards to get insight into health and status.

MySQL/Monitoring

The MySQL/Monitoring dashboard displays key metrics for your MySQL DB instances, including throughput, query performance, concurrency, and buffer pool usage summaries. As you identify significant trends and anomalies in this dashboard, you can pivot to other, more specific dashboards to dive into deeper investigations.

MySQL Monitoring. Summarizes throughput, query performance, concurrency, and buffer pool usage.

Figure 1 - MySQL/Monitoring dashboard

MySQL/Throughput

The MySQL/Throughput dashboard gives you a deeper view into the questions, reads, and writes on your instances overall and by instance.

MySQL Throughput. Visualizations include database questions, reads, and writes by instance.

Figure 2 - MySQL/Throughput dashboard

MySQL/Query Performance

With the MySQL/Query Performance dashboard, you can explore the rate and latency of queries, errors, and slow queries on your database instances. You can even inspect the queries that encountered slowness during execution.

MySQL Query Performance. Visualizations include query and error rates, slow query counts, and latency.

Figure 3 - MySQL/Query Performance dashboard

MySQL/Concurrency

The MySQL/Concurrency dashboard details the counts of connections and connection errors by instance in sum and over time.

MySQL Concurrency. Visualizations include counts of connections and connection errors by instance.

Figure 4 - MySQL/Concurrency dashboard

MySQL/Buffer Pool Usage

With the MySQL/Buffer Pool Usage dashboard, you can inspect how much of your buffer pool is in use as a percentage and bytes, and you can see how many reads and read requests were made on your instances’ buffer pools.

MySQL Buffer Pool Usage. Visualizations include usage percent and bytes, read and read-request counts by instance.

Figure 5 - MySQL/Buffer Pool Usage dashboard

MySQL/Configurations

By clicking through a specific resource instance, you can also review the global variables of your database instance in the MySQL/Configurations dashboard without logging into the server. You can filter these variables by substring to quickly find the specific configurations of interest.

MySQL Configurations. View an instance's global variable settings without having to leave Observe.

Figure 6 - MySQL/Configurations dashboard

Setup

The MySQL app ingests data using Fluentbit and Telegraf to collect MySQL DB logs. To install and configure data collection, see the MySQL DB Installation Guide.