Working with Reports

The MySQL cartridge includes a variety of preconfigured reports designed to provide insights into MySQL environments. These reports can be copied, modified, disabled, or customized as needed. For more information, refer to Working with Reports or contact Quest Software PSO.

This section describes the following reports:

Current Connections

Displays connections from the latest sample within the selected time range.

Executive Summary

Provides a summary of MySQL instance performance, including workload, availability, and key performance metrics.

Failed Logins

Displays failed login attempts to the MySQL server within the selected time range, along with generated error counts.

Galera Cluster Summary

Summarizes Galera cluster health, membership, and key performance metrics from monitored nodes within the selected time range.

Health Check Report

Provides an overview of various aspects of the specified instance’s health.

InnoDB Cluster Report

Displays detailed information on a MySQL InnoDB Cluster.

MySQL Server Configuration

Lists current configuration properties for a MySQL server, including a change history for the specified time range.

MySQL Server Configuration Comparison

Compares configuration properties across a group of MySQL servers against a designated template server. Reports variances per property and per server, using the most recent values collected.

Storage Report

Shows information on MySQL server storage capacity, growth rates, and usage trends.

Top MySQL Servers by Connections

Lists top MySQL servers in the selected service, ranked by metrics such as successful connections, aborted connects, success percentage, or aborted clients.

Top MySQL Tables

Displays top tables on a MySQL server, ranked by metrics such as total size, row count, used space percentage, or growth rate.

Top Statement Digests

Highlights top statement digests on a MySQL server, ranked by count, average wait time, total wait time, maximum wait time, average lock time, warnings, or errors. Statements from performance_schema and mysql databases are filtered by default.

Users Report

Shows information about MySQL users, including connections and privileges.