MySQL Dashboard

This dashboard provides comprehensive monitoring of MySQL database performance and resource utilization, offering detailed visibility into connections, locks, buffer pool operations, table I/O events, and various database metrics.

Dashboard Preview

Dashboards → + New dashboard → Import JSON

What This Dashboard Monitors

This dashboard tracks essential MySQL metrics to help you:

Monitor Connection Health: Track database connections and connection errors
Analyze Lock Performance: Monitor MySQL locks and row-level locking behavior
Track Buffer Pool Usage: Analyze InnoDB buffer pool efficiency and page management
Monitor Table I/O Operations: Track table-level I/O wait events and performance
Analyze Resource Utilization: Monitor threads, handlers, and prepared statements
Database Performance Optimization: Identify bottlenecks and optimize database operations

Metrics Included

Connection Metrics

Connection/Errors: Shows database connection count and connection errors over time

Performance Metrics

Count by Handlers: Shows MySQL handler operations count by type over time
Row Operations: Shows row-level operations (read, insert, delete, update) over time
Count of Operations: Shows count of database operations by operation type

Lock Metrics

MySQL Locks: Shows MySQL lock types (immediate, waited) over time
Row Locks: Shows InnoDB row lock operations (waits, time) over time

Resource Metrics

Open Resources Count: Shows count of open MySQL resources by type over time
Thread Type Count: Shows MySQL thread counts by thread type (running, connected, created, cached)
Prepared Statement Count: Shows prepared statement counts by command type

Storage Metrics

InnoDB Log Operations: Shows InnoDB log operations count by operation type

Buffer Pool Metrics

Buffer Pool Usage by Status: Shows buffer pool memory usage by status (clean, dirty) over time
Data Pages by Status: Shows buffer pool data pages by status (clean, dirty) over time
Buffer Pool Pages by Kind: Shows buffer pool pages count by page kind over time
Total Buffer Pool Page Flushes: Shows total count of buffer pool page flush operations over time

Table I/O Metrics

Count of Table I/O Wait Events: Shows count of table I/O wait events by table
Table I/O Wait Events Time: Shows time spent in table I/O wait events by table