MySQL Query Performance Troubleshooting (Designed for PMM2)
2,671 4.3 (3 reviews)
Get Dashboard

Created 7/12/2020

Updated 7/12/2020

Revision 1

Description

This dashboards allows you to troubleshoot queries which are heavy on system resources CPU, Disk, Network, Memory or which cause extensive Locking on the database level

Screenshots

Source Grafana.com

Used Metrics 17

interval
mysql_global_status_innodb_row_lock_time
mysql_global_status_queries
mysql_global_status_threads_running
mysql_global_status_uptime
mysql_global_variables_innodb_buffer_pool_size
node_boot_time_seconds
node_filesystem_free_bytes
node_filesystem_size_bytes
node_load1
node_memory_Buffers_bytes
node_memory_Cached_bytes
node_memory_MemAvailable_bytes
node_memory_MemFree_bytes
node_memory_MemTotal_bytes
node_memory_SwapTotal_bytes
node_time_seconds

Get Dashboard✕

Download

Copy to Clipboard