Understand MySQL dashboards

The MySQL integration provides two pre-built dashboards that you can use immediately to begin monitoring and troubleshooting database performance issues. In this step of the journey, you’ll become familiar with these pre-built dashboards and learn how to use them to address various problems.

While this journey focuses on configuring the MySQL integration for one instance, the following dashboard images show the kinds of data you’ll see when you monitor multiple MySQL instances across your infrastructure.

Did you know? If you don’t see any metrics, try switching the data source using the drop-down at the top of the dashboard.

MySQL overview dashboard

This dashboard provides a comprehensive overview of your MySQL database performance and health, including:

• Connection metrics: Active connections, connection rate, and connection errors
• Query performance: Query rate, slow queries, and query execution statistics
• InnoDB buffer pool: Buffer pool usage, hit ratio, and page statistics
• Replication status: Replication lag, slave status, and synchronization health
• Resource utilization: CPU usage, memory consumption, and disk I/O metrics

Use this dashboard to:

• Monitor overall database health and performance trends
• Track connection usage and identify potential connection issues
• Analyze query performance and identify slow operations
• Monitor memory and storage utilization for capacity planning
• Ensure replication consistency and performance

MySQL logs dashboard

This dashboard focuses on log analysis and troubleshooting, including:

• Error patterns: Monitor error frequencies and types
• Authentication events: Track login failures and security events
• Slow query analysis: Identify queries requiring performance optimization
• Database operations: Monitor startup, shutdown, and maintenance events
• Audit information: Review general query logs for compliance and debugging

Use this dashboard to:

• Troubleshoot database issues using log analysis
• Monitor security events and authentication patterns
• Identify performance bottlenecks through slow query analysis
• Track database operational events and maintenance activities
• Ensure compliance and audit trail requirements

In your final milestone, you’ll complete the MySQL monitoring journey.

More to explore (optional)

• Build a dashboard

Troubleshooting

Explore the following troubleshooting topic if you need help:

• I don’t see MySQL metrics in the dashboard
• I don’t see logs in the log dashboard