MySQL/MariaDB Workload 2,1082,108
MySQL/MariaDB Workload
MariaDB Workload Overview Innodb, I/O, Waits, etc
REFS
- Based on Perconda Dashboards https://github.com/percona/grafana-dashboards
- Collector https://github.com/prometheus/mysqld_exporter
Used Metrics 140140
-
mysql_global_status_uptime
-
mysql_global_status_queries
interval
-
mysql_global_variables_innodb_buffer_pool_size
node_memory_MemTotal
mysql_info_schema_query_response_time_seconds_bucket
mysql_info_schema_query_response_time_seconds_sum
mysql_info_schema_query_response_time_seconds_count
-
mysql_global_status_threads_connected
-
mysql_global_status_max_used_connections
-
mysql_global_variables_max_connections
-
mysql_global_status_threads_running
-
mysql_global_status_questions
-
mysql_global_status_innodb_row_ops_total
mysql_global_status_rows_sent
mysql_global_status_rows_read
mysql_global_status_rows_tmp_read
-
mysql_global_status_innodb_buffer_pool_read_requests
-
mysql_global_status_innodb_buffer_pool_write_requests
-
mysql_global_status_innodb_buffer_pool_reads
-
mysql_global_status_innodb_data_reads
mysql_info_schema_innodb_metrics_recovery_log_lsn_checkpoint_age_total
mysql_info_schema_innodb_metrics_recovery_log_max_modified_age_async
mysql_info_schema_innodb_metrics_recovery_log_max_modified_age_sync
-
mysql_global_variables_innodb_log_files_in_group
-
mysql_global_variables_innodb_log_file_size
-
mysql_global_variables_innodb_adaptive_flushing_lwm
-
mysql_global_variables_innodb_adaptive_flushing
-
mysql_global_status_innodb_data_writes
-
mysql_global_status_innodb_data_fsyncs
-
mysql_global_status_innodb_os_log_fsyncs
-
mysql_global_status_innodb_log_writes
-
mysql_global_variables_innodb_io_capacity
-
mysql_global_status_innodb_buffer_pool_bytes_data
-
mysql_global_status_innodb_buffer_pool_bytes_dirty
-
mysql_global_variables_innodb_max_dirty_pages_pct
-
mysql_global_variables_innodb_max_dirty_pages_pct_lwm
-
mysql_global_status_innodb_os_log_written
-
mysql_global_status_innodb_data_written
-
mysql_global_status_innodb_data_read
-
mysql_global_status_innodb_log_waits
-
mysql_global_status_innodb_buffer_pool_wait_free
-
mysql_global_variables_innodb_log_buffer_size
mysql_global_status_innodb_max_trx_id
mysql_info_schema_innodb_metrics_transaction_trx_rseg_history_len
incr_interval
-
mysql_global_status_innodb_pages_created
-
mysql_global_status_innodb_pages_read
-
mysql_global_status_innodb_pages_written
mysql_global_status_innodb_ibuf_merges
mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_total
mysql_global_status_innodb_ibuf_merged_inserts
mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_insert_total
mysql_global_status_innodb_ibuf_merged_deletes
mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_delete_total
mysql_global_status_innodb_ibuf_merged_delete_marks
mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_delete_mark_total
-
mysql_global_status_innodb_buffer_pool_read_ahead
-
mysql_global_status_innodb_buffer_pool_read_ahead_rnd
-
mysql_global_status_innodb_buffer_pool_read_ahead_evicted
-
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_innodb_row_lock_time
-
mysql_global_status_innodb_row_lock_waits
-
mysql_global_status_created_tmp_tables
-
mysql_global_status_created_tmp_disk_tables
-
mysql_global_status_created_tmp_files
mysql_global_status_innodb_deadlocks
mysql_info_schema_innodb_metrics_lock_lock_deadlocks_total
-
mysql_global_status_sort_rows
-
mysql_global_status_sort_range
-
mysql_global_status_sort_merge_passes
-
mysql_global_status_sort_scan
-
mysql_global_status_slow_queries
-
mysql_global_variables_thread_cache_size
-
mysql_global_status_threads_cached
-
mysql_global_status_threads_created
mysql_global_variables_thread_pool_size
mysql_global_status_threadpool_threads
mysql_global_status_threadpool_idle_threads
-
mysql_global_status_aborted_connects
-
mysql_global_status_aborted_clients
-
mysql_global_status_table_locks_immediate
-
mysql_global_status_table_locks_waited
topk
-
mysql_global_status_commands_total
-
mysql_global_status_bytes_received
-
mysql_global_status_bytes_sent
-
mysql_global_status_innodb_page_size
-
mysql_global_status_buffer_pool_pages
mysql_global_variables_innodb_additional_mem_pool_size
mysql_global_status_innodb_mem_dictionary
-
mysql_global_variables_key_buffer_size
mysql_global_variables_query_cache_size
mysql_global_status_innodb_mem_adaptive_hash
mysql_global_variables_tokudb_cache_size
-
mysql_global_status_handlers_total
mysql_info_schema_threads
mysql_global_status_qcache_free_memory
mysql_global_status_qcache_hits
mysql_global_status_qcache_inserts
mysql_global_status_qcache_not_cached
mysql_global_status_qcache_lowmem_prunes
mysql_global_status_qcache_queries_in_cache
-
mysql_global_status_opened_files
-
mysql_global_status_open_files
-
mysql_global_variables_open_files_limit
-
mysql_global_status_innodb_num_open_files
-
mysql_global_status_opened_tables
-
mysql_global_status_table_open_cache_hits
-
mysql_global_status_table_open_cache_misses
-
mysql_global_status_table_open_cache_overflows
-
mysql_global_status_open_tables
-
mysql_global_variables_table_open_cache
-
mysql_global_status_open_table_definitions
-
mysql_global_variables_table_definition_cache
-
mysql_global_status_opened_table_definitions
-
node_vmstat_pgpgin
-
node_vmstat_pgpgout
node_memory_MemFree
node_memory_Buffers
node_memory_Cached
node_cpu
node_cpu_average
-
node_load1
node_disk_read_time_ms
node_disk_reads_completed
aws_rds_read_latency_average
node_disk_write_time_ms
node_disk_writes_completed
aws_rds_write_latency_average
node_network_receive_bytes
rdsosmetrics_network_rx
node_network_transmit_bytes
rdsosmetrics_network_tx
-
node_vmstat_pswpin
-
node_vmstat_pswpout