Visualization and monitoring solutions
Visualization and monitoring solutions  /  Monitor MySQL
MySQL logo

Monitor MySQL easily with Grafana

Easily monitor your deployment of MySQL, the popular open source data management system, with Grafana Cloud’s out-of-the-box monitoring solution. The Grafana Cloud forever-free tier includes 3 users and up to 10k metrics series to support your monitoring needs.

MySQL integration for Grafana Cloud

The MySQL integration for Grafana Cloud enables robust monitoring of MySQL databases, featuring pre-configured dashboards and alerts to track performance metrics like query response times, connection usage, and error rates. This integration helps you efficiently identify and resolve database issues, enhancing the overall reliability and performance of your MySQL instances.

A running MySQL instance, user, and password are required for the integration. The supported versions include:

  • MySQL >= 5.6
  • MariaDB >= 10.2

Observability signals for MySQL

MySQL overview
MySQL overview
MySQL logs
MySQL logs
Example dashboard to monitor MySQL

Key metrics included

asserts:mixin_workload_job
instance:mysql_heartbeat_lag_seconds
instance:mysql_slave_lag_seconds
mysql_global_status_aborted_clients
mysql_global_status_aborted_connects
mysql_global_status_binlog_cache_disk_use
mysql_global_status_binlog_cache_use
mysql_global_status_binlog_stmt_cache_disk_use
mysql_global_status_binlog_stmt_cache_use
mysql_global_status_buffer_pool_pages
mysql_global_status_bytes_received
mysql_global_status_bytes_sent
mysql_global_status_commands_total
mysql_global_status_connections
mysql_global_status_created_tmp_disk_tables
mysql_global_status_created_tmp_files
mysql_global_status_created_tmp_tables
mysql_global_status_handlers_total
mysql_global_status_innodb_buffer_pool_bytes_data
mysql_global_status_innodb_data_read
mysql_global_status_innodb_data_written
mysql_global_status_innodb_log_waits
mysql_global_status_innodb_mem_adaptive_hash
mysql_global_status_innodb_mem_dictionary
mysql_global_status_innodb_num_open_files
mysql_global_status_innodb_page_size
mysql_global_status_innodb_pages_written
mysql_global_status_key_blocks_unused
mysql_global_status_key_blocks_used
mysql_global_status_max_used_connections
mysql_global_status_open_files
mysql_global_status_open_table_definitions
mysql_global_status_open_tables
mysql_global_status_opened_files
mysql_global_status_opened_table_definitions
mysql_global_status_opened_tables
mysql_global_status_qcache_free_memory
mysql_global_status_qcache_hits
mysql_global_status_qcache_inserts
mysql_global_status_qcache_lowmem_prunes
mysql_global_status_qcache_not_cached
mysql_global_status_qcache_queries_in_cache
mysql_global_status_queries
mysql_global_status_questions
mysql_global_status_select_full_join
mysql_global_status_select_full_range_join
mysql_global_status_select_range
mysql_global_status_select_range_check
mysql_global_status_select_scan
mysql_global_status_slow_queries
mysql_global_status_sort_merge_passes
mysql_global_status_sort_range
mysql_global_status_sort_rows
mysql_global_status_sort_scan
mysql_global_status_table_locks_immediate
mysql_global_status_table_locks_waited
mysql_global_status_table_open_cache_hits
mysql_global_status_table_open_cache_misses
mysql_global_status_table_open_cache_overflows
mysql_global_status_threads_cached
mysql_global_status_threads_connected
mysql_global_status_threads_created
mysql_global_status_threads_running
mysql_global_status_uptime
mysql_global_status_wsrep_local_recv_queue
mysql_global_status_wsrep_local_state
mysql_global_status_wsrep_ready
mysql_global_variables_innodb_additional_mem_pool_size
mysql_global_variables_innodb_buffer_pool_size
mysql_global_variables_innodb_log_buffer_size
mysql_global_variables_key_buffer_size
mysql_global_variables_max_connections
mysql_global_variables_open_files_limit
mysql_global_variables_query_cache_size
mysql_global_variables_table_definition_cache
mysql_global_variables_table_open_cache
mysql_global_variables_thread_cache_size
mysql_global_variables_tokudb_cache_size
mysql_global_variables_wsrep_desync
mysql_heartbeat_now_timestamp_seconds
mysql_heartbeat_stored_timestamp_seconds
mysql_info_schema_processlist_threads
mysql_slave_status_seconds_behind_master
mysql_slave_status_slave_io_running
mysql_slave_status_slave_sql_running
mysql_slave_status_sql_delay
mysql_up
up

Key alerting rules included

MySQLDown (Critical)
MySQLRestarted (Critical)
MySQLSlowQueries (Warning)
MySQLTuneThreadCacheSize (Warning)
MySQLInsufficientTempTableSize (Warning)
MySQLInsufficientBinLogCacheSize (Warning)
MySQLInsufficientBinLogStmtCacheSize (Warning)
MySQLGaleraNotReady (Warning)
MySQLGaleraOutOfSync (Warning)
MySQLGaleraDonorFallingBehind (Warning)
MySQLReplicationNotRunning (Critical)
MySQLReplicationLag (Critical)
MySQLHeartbeatLag (Critical)
MySQLInnoDBLogWaits (Warning)
MySQLSlaveBehindMaster (Warning)