MySQL 8.0 Overview 1,0761,076
I have use a PMM2 dashboard which is very useful. I want to summary a dashboard. This dashboard tested in MySQL 8.0.33
Thank you
Used Metrics 121121
-
mysql_global_status_threads_connected
-
mysql_global_status_commands_total
-
node_boot_time_seconds
-
node_cpu_seconds_total
interval
-
node_memory_MemTotal_bytes
-
node_memory_Shmem_bytes
-
node_memory_Buffers_bytes
-
node_memory_Cached_bytes
-
node_memory_MemFree_bytes
-
node_load1
-
node_load5
-
node_load15
-
node_network_receive_bytes_total
-
node_network_transmit_bytes_total
node_tcp_connection_states
-
node_disk_read_bytes_total
-
node_disk_written_bytes_total
-
mysql_global_status_innodb_data_reads
-
node_vmstat_pgpgout
-
node_vmstat_pgpgin
-
node_disk_read_time_seconds_total
rdsosmetrics_diskIO_readIOsPS
-
node_disk_write_time_seconds_total
rdsosmetrics_diskIO_writeIOsPS
-
node_disk_reads_completed_total
aws_rds_read_latency_average
rdsosmetrics_diskIO_readLatency
-
node_disk_writes_completed_total
aws_rds_write_latency_average
rdsosmetrics_diskIO_writeLatency
-
mysql_global_status_uptime
-
mysql_version_info
-
mysql_global_status_queries
topk
-
mysql_global_status_bytes_received
-
mysql_global_status_bytes_sent
-
mysql_global_status_aborted_clients
-
mysql_global_status_aborted_connects
-
mysql_global_status_threads_running
-
mysql_global_status_threads_cached
-
mysql_global_status_threads_created
-
mysql_global_status_open_tables
-
mysql_global_status_open_files
-
mysql_global_status_connections
-
mysql_global_variables_max_connections
mysql_info_schema_processlist_threads
-
mysql_global_status_opened_tables
-
mysql_global_status_table_open_cache_hits
-
mysql_global_status_table_open_cache_misses
-
mysql_global_status_table_locks_immediate
-
mysql_global_status_table_locks_waited
-
mysql_global_status_select_scan
-
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_sort_rows
-
mysql_global_status_sort_scan
-
mysql_global_status_sort_merge_passes
-
mysql_global_status_sort_range
-
mysql_global_status_created_tmp_tables
-
mysql_global_status_created_tmp_disk_tables
-
mysql_global_status_created_tmp_files
-
mysql_global_status_handlers_total
-
mysql_global_status_binlog_cache_use
-
mysql_global_status_binlog_cache_disk_use
-
mysql_global_status_binlog_stmt_cache_disk_use
-
mysql_global_variables_innodb_buffer_pool_size
-
mysql_global_variables_innodb_log_buffer_size
mysql_global_variables_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_variables_innodb_old_blocks_pct
-
mysql_global_variables_innodb_sort_buffer_size
-
mysql_global_status_buffer_pool_pages
-
mysql_global_status_innodb_buffer_pool_write_requests
mysql_info_schema_table_version
mysql_info_schema_table_size
-
mysql_global_status_innodb_buffer_pool_reads
-
mysql_global_status_innodb_buffer_pool_read_requests
mysql_info_schema_innodb_metrics_file_system_file_num_open_files
-
mysql_global_variables_innodb_file_per_table
mysql_info_schema_table_rows
-
mysql_global_variables_innodb_buffer_pool_dump_pct
-
mysql_global_variables_innodb_dedicated_server
-
mysql_global_variables_innodb_stats_auto_recalc
-
mysql_global_variables_innodb_stats_on_metadata
-
mysql_global_variables_innodb_stats_persistent
-
mysql_global_variables_innodb_stats_persistent_sample_pages
-
mysql_global_variables_innodb_stats_transient_sample_pages
-
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_status_innodb_pages_created
-
mysql_global_status_innodb_pages_read
-
mysql_global_status_innodb_pages_written
-
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_info_schema_innodb_metrics_server_innodb_activity_count_total
-
mysql_global_status_innodb_row_ops_total
-
mysql_global_variables_innodb_lock_wait_timeout
-
mysql_global_variables_innodb_deadlock_detect
-
mysql_global_variables_innodb_rollback_on_timeout
-
mysql_global_status_innodb_row_lock_time
-
mysql_global_status_innodb_row_lock_waits
mysql_global_status_innodb_deadlocks
mysql_info_schema_innodb_metrics_lock_lock_deadlocks_total
mysql_info_schema_innodb_metrics_lock_lock_timeouts_total
-
mysql_global_status_innodb_page_size
-
mysql_global_status_innodb_data_read
-
mysql_global_status_innodb_data_written
-
mysql_global_status_innodb_data_writes
-
mysql_global_status_innodb_os_log_written
-
mysql_global_status_innodb_log_writes
-
mysql_global_status_innodb_data_fsyncs
-
mysql_global_status_innodb_os_log_fsyncs