mysql collector

mysql collects MySQL instance statistics

The common collector's configuration is:

Parameter	Type	Default	Description
id	String		Collector's ID. Must be unique per agent instance.
type	String		Must be mysql
interval	Integer	agent.defaults.interval	Repetition interval in seconds
labels	Object		Additional collector-level labels
relabel	Array		Optional relabeling rules. See Relabeling Rules for details

The collector-specific configuration is:

Parameter	Type	Default	Description
host	String		Server instance host for TCP connection
port	Integer		Server instance port for TCP connection
username	String		Username to connect database
password	String		Password to connect database

Config example:

- id: mysql
  disabled: false
  type: mysql
  host: 127.0.0.1
  username: root
  password: secret

Collected Metrics

OpenMetrics

Metric	Metric Type	Description
mysql_aborted_clients	Gauge	???
mysql_aborted_connects	Gauge	???
mysql_acl_cache_items_count	Gauge	???
mysql_binlog_cache_disk_use	Gauge	???
mysql_binlog_cache_use	Gauge	???
mysql_binlog_stmt_cache_disk_use	Gauge	???
mysql_binlog_stmt_cache_use	Gauge	???
mysql_bytes_received	Gauge	???
mysql_bytes_sent	Gauge	???
mysql_com_admin_commands	Gauge	???
mysql_com_alter_db	Gauge	???
mysql_com_alter_event	Gauge	???
mysql_com_alter_function	Gauge	???
mysql_com_alter_instance	Gauge	???
mysql_com_alter_procedure	Gauge	???
mysql_com_alter_resource_group	Gauge	???
mysql_com_alter_server	Gauge	???
mysql_com_alter_table	Gauge	???
mysql_com_alter_tablespace	Gauge	???
mysql_com_alter_user	Gauge	???
mysql_com_alter_user_default_role	Gauge	???
mysql_com_analyze	Gauge	???
mysql_com_assign_to_keycache	Gauge	???
mysql_com_begin	Gauge	???
mysql_com_binlog	Gauge	???
mysql_com_call_procedure	Gauge	???
mysql_com_change_db	Gauge	???
mysql_com_change_master	Gauge	???
mysql_com_change_repl_filter	Gauge	???
mysql_com_change_replication_source	Gauge	???
mysql_com_check	Gauge	???
mysql_com_checksum	Gauge	???
mysql_com_clone	Gauge	???
mysql_com_commit	Gauge	???
mysql_com_create_db	Gauge	???
mysql_com_create_event	Gauge	???
mysql_com_create_function	Gauge	???
mysql_com_create_index	Gauge	???
mysql_com_create_procedure	Gauge	???
mysql_com_create_resource_group	Gauge	???
mysql_com_create_role	Gauge	???
mysql_com_create_server	Gauge	???
mysql_com_create_spatial_reference_system	Gauge	???
mysql_com_create_table	Gauge	???
mysql_com_create_trigger	Gauge	???
mysql_com_create_udf	Gauge	???
mysql_com_create_user	Gauge	???
mysql_com_create_view	Gauge	???
mysql_com_dealloc_sql	Gauge	???
mysql_com_delete	Gauge	???
mysql_com_delete_multi	Gauge	???
mysql_com_do	Gauge	???
mysql_com_drop_db	Gauge	???
mysql_com_drop_event	Gauge	???
mysql_com_drop_function	Gauge	???
mysql_com_drop_index	Gauge	???
mysql_com_drop_procedure	Gauge	???
mysql_com_drop_resource_group	Gauge	???
mysql_com_drop_role	Gauge	???
mysql_com_drop_server	Gauge	???
mysql_com_drop_spatial_reference_system	Gauge	???
mysql_com_drop_table	Gauge	???
mysql_com_drop_trigger	Gauge	???
mysql_com_drop_user	Gauge	???
mysql_com_drop_view	Gauge	???
mysql_com_empty_query	Gauge	???
mysql_com_execute_sql	Gauge	???
mysql_com_explain_other	Gauge	???
mysql_com_flush	Gauge	???
mysql_com_get_diagnostics	Gauge	???
mysql_com_grant	Gauge	???
mysql_com_grant_roles	Gauge	???
mysql_com_group_replication_start	Gauge	???
mysql_com_group_replication_stop	Gauge	???
mysql_com_ha_close	Gauge	???
mysql_com_ha_open	Gauge	???
mysql_com_ha_read	Gauge	???
mysql_com_help	Gauge	???
mysql_com_import	Gauge	???
mysql_com_insert	Gauge	???
mysql_com_insert_select	Gauge	???
mysql_com_install_component	Gauge	???
mysql_com_install_plugin	Gauge	???
mysql_com_kill	Gauge	???
mysql_com_load	Gauge	???
mysql_com_lock_instance	Gauge	???
mysql_com_lock_tables	Gauge	???
mysql_com_optimize	Gauge	???
mysql_com_preload_keys	Gauge	???
mysql_com_prepare_sql	Gauge	???
mysql_com_purge	Gauge	???
mysql_com_purge_before_date	Gauge	???
mysql_com_release_savepoint	Gauge	???
mysql_com_rename_table	Gauge	???
mysql_com_rename_user	Gauge	???
mysql_com_repair	Gauge	???
mysql_com_replace	Gauge	???
mysql_com_replace_select	Gauge	???
mysql_com_replica_start	Gauge	???
mysql_com_replica_stop	Gauge	???
mysql_com_reset	Gauge	???
mysql_com_resignal	Gauge	???
mysql_com_restart	Gauge	???
mysql_com_revoke	Gauge	???
mysql_com_revoke_all	Gauge	???
mysql_com_revoke_roles	Gauge	???
mysql_com_rollback	Gauge	???
mysql_com_rollback_to_savepoint	Gauge	???
mysql_com_savepoint	Gauge	???
mysql_com_select	Gauge	???
mysql_com_set_option	Gauge	???
mysql_com_set_password	Gauge	???
mysql_com_set_resource_group	Gauge	???
mysql_com_set_role	Gauge	???
mysql_com_show_binlog_events	Gauge	???
mysql_com_show_binlogs	Gauge	???
mysql_com_show_charsets	Gauge	???
mysql_com_show_collations	Gauge	???
mysql_com_show_create_db	Gauge	???
mysql_com_show_create_event	Gauge	???
mysql_com_show_create_func	Gauge	???
mysql_com_show_create_proc	Gauge	???
mysql_com_show_create_table	Gauge	???
mysql_com_show_create_trigger	Gauge	???
mysql_com_show_create_user	Gauge	???
mysql_com_show_databases	Gauge	???
mysql_com_show_engine_logs	Gauge	???
mysql_com_show_engine_mutex	Gauge	???
mysql_com_show_engine_status	Gauge	???
mysql_com_show_errors	Gauge	???
mysql_com_show_events	Gauge	???
mysql_com_show_fields	Gauge	???
mysql_com_show_function_code	Gauge	???
mysql_com_show_function_status	Gauge	???
mysql_com_show_grants	Gauge	???
mysql_com_show_keys	Gauge	???
mysql_com_show_master_status	Gauge	???
mysql_com_show_open_tables	Gauge	???
mysql_com_show_plugins	Gauge	???
mysql_com_show_privileges	Gauge	???
mysql_com_show_procedure_code	Gauge	???
mysql_com_show_procedure_status	Gauge	???
mysql_com_show_processlist	Gauge	???
mysql_com_show_profile	Gauge	???
mysql_com_show_profiles	Gauge	???
mysql_com_show_relaylog_events	Gauge	???
mysql_com_show_replica_status	Gauge	???
mysql_com_show_replicas	Gauge	???
mysql_com_show_slave_hosts	Gauge	???
mysql_com_show_slave_status	Gauge	???
mysql_com_show_status	Gauge	???
mysql_com_show_storage_engines	Gauge	???
mysql_com_show_table_status	Gauge	???
mysql_com_show_tables	Gauge	???
mysql_com_show_triggers	Gauge	???
mysql_com_show_variables	Gauge	???
mysql_com_show_warnings	Gauge	???
mysql_com_shutdown	Gauge	???
mysql_com_signal	Gauge	???
mysql_com_slave_start	Gauge	???
mysql_com_slave_stop	Gauge	???
mysql_com_stmt_close	Gauge	???
mysql_com_stmt_execute	Gauge	???
mysql_com_stmt_fetch	Gauge	???
mysql_com_stmt_prepare	Gauge	???
mysql_com_stmt_reprepare	Gauge	???
mysql_com_stmt_reset	Gauge	???
mysql_com_stmt_send_long_data	Gauge	???
mysql_com_truncate	Gauge	???
mysql_com_uninstall_component	Gauge	???
mysql_com_uninstall_plugin	Gauge	???
mysql_com_unlock_instance	Gauge	???
mysql_com_unlock_tables	Gauge	???
mysql_com_update	Gauge	???
mysql_com_update_multi	Gauge	???
mysql_com_xa_commit	Gauge	???
mysql_com_xa_end	Gauge	???
mysql_com_xa_prepare	Gauge	???
mysql_com_xa_recover	Gauge	???
mysql_com_xa_rollback	Gauge	???
mysql_com_xa_start	Gauge	???
mysql_connection_errors_accept	Gauge	???
mysql_connection_errors_internal	Gauge	???
mysql_connection_errors_max_connections	Gauge	???
mysql_connection_errors_peer_address	Gauge	???
mysql_connection_errors_select	Gauge	???
mysql_connection_errors_tcpwrap	Gauge	???
mysql_connections	Gauge	???
mysql_created_tmp_disk_tables	Gauge	???
mysql_created_tmp_files	Gauge	???
mysql_created_tmp_tables	Gauge	???
mysql_delayed_errors	Gauge	???
mysql_delayed_insert_threads	Gauge	???
mysql_delayed_writes	Gauge	???
mysql_error_log_buffered_bytes	Gauge	???
mysql_error_log_buffered_events	Gauge	???
mysql_error_log_expired_events	Gauge	???
mysql_error_log_latest_write	Gauge	???
mysql_flush_commands	Gauge	???
mysql_global_connection_memory	Gauge	???
mysql_handler_commit	Gauge	???
mysql_handler_delete	Gauge	???
mysql_handler_discover	Gauge	???
mysql_handler_external_lock	Gauge	???
mysql_handler_mrr_init	Gauge	???
mysql_handler_prepare	Gauge	???
mysql_handler_read_first	Gauge	???
mysql_handler_read_key	Gauge	???
mysql_handler_read_last	Gauge	???
mysql_handler_read_next	Gauge	???
mysql_handler_read_prev	Gauge	???
mysql_handler_read_rnd	Gauge	???
mysql_handler_read_rnd_next	Gauge	???
mysql_handler_rollback	Gauge	???
mysql_handler_savepoint	Gauge	???
mysql_handler_savepoint_rollback	Gauge	???
mysql_handler_update	Gauge	???
mysql_handler_write	Gauge	???
mysql_innodb_buffer_pool_bytes_data	Gauge	???
mysql_innodb_buffer_pool_bytes_dirty	Gauge	???
mysql_innodb_buffer_pool_pages_data	Gauge	???
mysql_innodb_buffer_pool_pages_dirty	Gauge	???
mysql_innodb_buffer_pool_pages_flushed	Gauge	???
mysql_innodb_buffer_pool_pages_free	Gauge	???
mysql_innodb_buffer_pool_pages_misc	Gauge	???
mysql_innodb_buffer_pool_pages_total	Gauge	???
mysql_innodb_buffer_pool_read_ahead	Gauge	???
mysql_innodb_buffer_pool_read_ahead_evicted	Gauge	???
mysql_innodb_buffer_pool_read_ahead_rnd	Gauge	???
mysql_innodb_buffer_pool_read_requests	Gauge	???
mysql_innodb_buffer_pool_reads	Gauge	???
mysql_innodb_buffer_pool_resize_status_code	Gauge	???
mysql_innodb_buffer_pool_resize_status_progress	Gauge	???
mysql_innodb_buffer_pool_wait_free	Gauge	???
mysql_innodb_buffer_pool_write_requests	Gauge	???
mysql_innodb_data_fsyncs	Gauge	???
mysql_innodb_data_pending_fsyncs	Gauge	???
mysql_innodb_data_pending_reads	Gauge	???
mysql_innodb_data_pending_writes	Gauge	???
mysql_innodb_data_read	Gauge	???
mysql_innodb_data_reads	Gauge	???
mysql_innodb_data_writes	Gauge	???
mysql_innodb_data_written	Gauge	???
mysql_innodb_dblwr_pages_written	Gauge	???
mysql_innodb_dblwr_writes	Gauge	???
mysql_innodb_log_waits	Gauge	???
mysql_innodb_log_write_requests	Gauge	???
mysql_innodb_log_writes	Gauge	???
mysql_innodb_num_open_files	Gauge	???
mysql_innodb_os_log_fsyncs	Gauge	???
mysql_innodb_os_log_pending_fsyncs	Gauge	???
mysql_innodb_os_log_pending_writes	Gauge	???
mysql_innodb_os_log_written	Gauge	???
mysql_innodb_page_size	Gauge	???
mysql_innodb_pages_created	Gauge	???
mysql_innodb_pages_read	Gauge	???
mysql_innodb_pages_written	Gauge	???
mysql_innodb_redo_log_capacity_resized	Gauge	???
mysql_innodb_redo_log_checkpoint_lsn	Gauge	???
mysql_innodb_redo_log_current_lsn	Gauge	???
mysql_innodb_redo_log_flushed_to_disk_lsn	Gauge	???
mysql_innodb_redo_log_logical_size	Gauge	???
mysql_innodb_redo_log_physical_size	Gauge	???
mysql_innodb_redo_log_uuid	Gauge	???
mysql_innodb_row_lock_current_waits	Gauge	???
mysql_innodb_row_lock_time	Gauge	???
mysql_innodb_row_lock_time_avg	Gauge	???
mysql_innodb_row_lock_time_max	Gauge	???
mysql_innodb_row_lock_waits	Gauge	???
mysql_innodb_rows_deleted	Gauge	???
mysql_innodb_rows_inserted	Gauge	???
mysql_innodb_rows_read	Gauge	???
mysql_innodb_rows_updated	Gauge	???
mysql_innodb_sampled_pages_read	Gauge	???
mysql_innodb_sampled_pages_skipped	Gauge	???
mysql_innodb_system_rows_deleted	Gauge	???
mysql_innodb_system_rows_inserted	Gauge	???
mysql_innodb_system_rows_read	Gauge	???
mysql_innodb_system_rows_updated	Gauge	???
mysql_innodb_truncated_status_writes	Gauge	???
mysql_innodb_undo_tablespaces_active	Gauge	???
mysql_innodb_undo_tablespaces_explicit	Gauge	???
mysql_innodb_undo_tablespaces_implicit	Gauge	???
mysql_innodb_undo_tablespaces_total	Gauge	???
mysql_key_blocks_not_flushed	Gauge	???
mysql_key_blocks_unused	Gauge	???
mysql_key_blocks_used	Gauge	???
mysql_key_read_requests	Gauge	???
mysql_key_reads	Gauge	???
mysql_key_write_requests	Gauge	???
mysql_key_writes	Gauge	???
mysql_locked_connects	Gauge	???
mysql_max_execution_time_exceeded	Gauge	???
mysql_max_execution_time_set	Gauge	???
mysql_max_execution_time_set_failed	Gauge	???
mysql_max_used_connections	Gauge	???
mysql_mysqlx_aborted_clients	Gauge	???
mysql_mysqlx_bytes_received	Gauge	???
mysql_mysqlx_bytes_received_compressed_payload	Gauge	???
mysql_mysqlx_bytes_received_uncompressed_frame	Gauge	???
mysql_mysqlx_bytes_sent	Gauge	???
mysql_mysqlx_bytes_sent_compressed_payload	Gauge	???
mysql_mysqlx_bytes_sent_uncompressed_frame	Gauge	???
mysql_mysqlx_connection_accept_errors	Gauge	???
mysql_mysqlx_connection_errors	Gauge	???
mysql_mysqlx_connections_accepted	Gauge	???
mysql_mysqlx_connections_closed	Gauge	???
mysql_mysqlx_connections_rejected	Gauge	???
mysql_mysqlx_crud_create_view	Gauge	???
mysql_mysqlx_crud_delete	Gauge	???
mysql_mysqlx_crud_drop_view	Gauge	???
mysql_mysqlx_crud_find	Gauge	???
mysql_mysqlx_crud_insert	Gauge	???
mysql_mysqlx_crud_modify_view	Gauge	???
mysql_mysqlx_crud_update	Gauge	???
mysql_mysqlx_cursor_close	Gauge	???
mysql_mysqlx_cursor_fetch	Gauge	???
mysql_mysqlx_cursor_open	Gauge	???
mysql_mysqlx_errors_sent	Gauge	???
mysql_mysqlx_errors_unknown_message_type	Gauge	???
mysql_mysqlx_expect_close	Gauge	???
mysql_mysqlx_expect_open	Gauge	???
mysql_mysqlx_init_error	Gauge	???
mysql_mysqlx_messages_sent	Gauge	???
mysql_mysqlx_notice_global_sent	Gauge	???
mysql_mysqlx_notice_other_sent	Gauge	???
mysql_mysqlx_notice_warning_sent	Gauge	???
mysql_mysqlx_notified_by_group_replication	Gauge	???
mysql_mysqlx_port	Gauge	???
mysql_mysqlx_prep_deallocate	Gauge	???
mysql_mysqlx_prep_execute	Gauge	???
mysql_mysqlx_prep_prepare	Gauge	???
mysql_mysqlx_rows_sent	Gauge	???
mysql_mysqlx_sessions	Gauge	???
mysql_mysqlx_sessions_accepted	Gauge	???
mysql_mysqlx_sessions_closed	Gauge	???
mysql_mysqlx_sessions_fatal_error	Gauge	???
mysql_mysqlx_sessions_killed	Gauge	???
mysql_mysqlx_sessions_rejected	Gauge	???
mysql_mysqlx_ssl_accepts	Gauge	???
mysql_mysqlx_ssl_ctx_verify_depth	Gauge	???
mysql_mysqlx_ssl_ctx_verify_mode	Gauge	???
mysql_mysqlx_ssl_finished_accepts	Gauge	???
mysql_mysqlx_stmt_create_collection	Gauge	???
mysql_mysqlx_stmt_create_collection_index	Gauge	???
mysql_mysqlx_stmt_disable_notices	Gauge	???
mysql_mysqlx_stmt_drop_collection	Gauge	???
mysql_mysqlx_stmt_drop_collection_index	Gauge	???
mysql_mysqlx_stmt_enable_notices	Gauge	???
mysql_mysqlx_stmt_ensure_collection	Gauge	???
mysql_mysqlx_stmt_execute_mysqlx	Gauge	???
mysql_mysqlx_stmt_execute_sql	Gauge	???
mysql_mysqlx_stmt_execute_xplugin	Gauge	???
mysql_mysqlx_stmt_get_collection_options	Gauge	???
mysql_mysqlx_stmt_kill_client	Gauge	???
mysql_mysqlx_stmt_list_clients	Gauge	???
mysql_mysqlx_stmt_list_notices	Gauge	???
mysql_mysqlx_stmt_list_objects	Gauge	???
mysql_mysqlx_stmt_modify_collection_options	Gauge	???
mysql_mysqlx_stmt_ping	Gauge	???
mysql_mysqlx_worker_threads	Gauge	???
mysql_mysqlx_worker_threads_active	Gauge	???
mysql_not_flushed_delayed_rows	Gauge	???
mysql_ongoing_anonymous_transaction_count	Gauge	???
mysql_open_files	Gauge	???
mysql_open_streams	Gauge	???
mysql_open_table_definitions	Gauge	???
mysql_open_tables	Gauge	???
mysql_opened_files	Gauge	???
mysql_opened_table_definitions	Gauge	???
mysql_opened_tables	Gauge	???
mysql_performance_schema_accounts_lost	Gauge	???
mysql_performance_schema_cond_classes_lost	Gauge	???
mysql_performance_schema_cond_instances_lost	Gauge	???
mysql_performance_schema_digest_lost	Gauge	???
mysql_performance_schema_file_classes_lost	Gauge	???
mysql_performance_schema_file_handles_lost	Gauge	???
mysql_performance_schema_file_instances_lost	Gauge	???
mysql_performance_schema_hosts_lost	Gauge	???
mysql_performance_schema_index_stat_lost	Gauge	???
mysql_performance_schema_locker_lost	Gauge	???
mysql_performance_schema_memory_classes_lost	Gauge	???
mysql_performance_schema_metadata_lock_lost	Gauge	???
mysql_performance_schema_mutex_classes_lost	Gauge	???
mysql_performance_schema_mutex_instances_lost	Gauge	???
mysql_performance_schema_nested_statement_lost	Gauge	???
mysql_performance_schema_prepared_statements_lost	Gauge	???
mysql_performance_schema_program_lost	Gauge	???
mysql_performance_schema_rwlock_classes_lost	Gauge	???
mysql_performance_schema_rwlock_instances_lost	Gauge	???
mysql_performance_schema_session_connect_attrs_longest_seen	Gauge	???
mysql_performance_schema_session_connect_attrs_lost	Gauge	???
mysql_performance_schema_socket_classes_lost	Gauge	???
mysql_performance_schema_socket_instances_lost	Gauge	???
mysql_performance_schema_stage_classes_lost	Gauge	???
mysql_performance_schema_statement_classes_lost	Gauge	???
mysql_performance_schema_table_handles_lost	Gauge	???
mysql_performance_schema_table_instances_lost	Gauge	???
mysql_performance_schema_table_lock_stat_lost	Gauge	???
mysql_performance_schema_thread_classes_lost	Gauge	???
mysql_performance_schema_thread_instances_lost	Gauge	???
mysql_performance_schema_users_lost	Gauge	???
mysql_prepared_stmt_count	Gauge	???
mysql_queries	Gauge	???
mysql_questions	Gauge	???
mysql_replica_open_temp_tables	Gauge	???
mysql_secondary_engine_execution_count	Gauge	???
mysql_select_full_join	Gauge	???
mysql_select_full_range_join	Gauge	???
mysql_select_range	Gauge	???
mysql_select_range_check	Gauge	???
mysql_select_scan	Gauge	???
mysql_slave_open_temp_tables	Gauge	???
mysql_slow_launch_threads	Gauge	???
mysql_slow_queries	Gauge	???
mysql_sort_merge_passes	Gauge	???
mysql_sort_range	Gauge	???
mysql_sort_rows	Gauge	???
mysql_sort_scan	Gauge	???
mysql_ssl_accept_renegotiates	Gauge	???
mysql_ssl_accepts	Gauge	???
mysql_ssl_callback_cache_hits	Gauge	???
mysql_ssl_client_connects	Gauge	???
mysql_ssl_connect_renegotiates	Gauge	???
mysql_ssl_ctx_verify_depth	Gauge	???
mysql_ssl_ctx_verify_mode	Gauge	???
mysql_ssl_default_timeout	Gauge	???
mysql_ssl_finished_accepts	Gauge	???
mysql_ssl_finished_connects	Gauge	???
mysql_ssl_session_cache_hits	Gauge	???
mysql_ssl_session_cache_misses	Gauge	???
mysql_ssl_session_cache_overflows	Gauge	???
mysql_ssl_session_cache_size	Gauge	???
mysql_ssl_session_cache_timeout	Gauge	???
mysql_ssl_session_cache_timeouts	Gauge	???
mysql_ssl_sessions_reused	Gauge	???
mysql_ssl_used_session_cache_entries	Gauge	???
mysql_ssl_verify_depth	Gauge	???
mysql_ssl_verify_mode	Gauge	???
mysql_table_locks_immediate	Gauge	???
mysql_table_locks_waited	Gauge	???
mysql_table_open_cache_hits	Gauge	???
mysql_table_open_cache_misses	Gauge	???
mysql_table_open_cache_overflows	Gauge	???
mysql_tc_log_max_pages_used	Gauge	???
mysql_tc_log_page_size	Gauge	???
mysql_tc_log_page_waits	Gauge	???
mysql_threads_cached	Gauge	???
mysql_threads_connected	Gauge	???
mysql_threads_created	Gauge	???
mysql_threads_running	Gauge	???
mysql_uptime	Gauge	???
mysql_uptime_since_flush_status	Gauge	???

Labels

mysql collector do not appends labels

Label	Description

Sample Output

OpenMetrics