微信号:OpenFalcon

介绍:互联网企业级监控系统实践

MySQL指标采集和监控——OpenFalcon

2015-06-02 16:05 libin_cc

MySQL运行指标的采集和推送方案,发布到github了。

请参考: https://github.com/open-falcon/mymon 。

谢谢 libin_cc@微信 的支持。


采集的指标项可以参考 https://github.com/open-falcon/mymon/blob/master/metrics.txt ,共计400余项(根据MySQL版本或者配置不同而稍有差异)


效果图:



指标项列表参考


Aborted_clients

Aborted_connects

auto_increment_increment

auto_increment_offset

back_log

Binlog_cache_disk_use

binlog_cache_size

Binlog_cache_use

bulk_insert_buffer_size

Bytes_received

Bytes_sent

Com_admin_commands

Com_alter_db

Com_alter_db_upgrade

Com_alter_event

Com_alter_function

Com_alter_procedure

Com_alter_server

Com_alter_table

Com_alter_tablespace

Com_analyze

Com_assign_to_keycache

Com_backup_table

Com_begin

Com_binlog

Com_call_procedure

Com_change_db

Com_change_master

Com_check

Com_checksum

Com_commit

Com_create_db

Com_create_event

Com_create_function

Com_create_index

Com_create_procedure

Com_create_server

Com_create_table

Com_create_trigger

Com_create_udf

Com_create_user

Com_create_view

Com_dealloc_sql

Com_delete

Com_delete_multi

Com_do

Com_drop_db

Com_drop_event

Com_drop_function

Com_drop_index

Com_drop_procedure

Com_drop_server

Com_drop_table

Com_drop_trigger

Com_drop_user

Com_drop_view

Com_empty_query

Com_execute_sql

Com_flush

Com_grant

Com_ha_close

Com_ha_open

Com_ha_read

Com_help

Com_insert

Com_insert_select

Com_install_plugin

Com_kill

Com_load

Com_load_master_data

Com_load_master_table

Com_lock_tables

Com_optimize

completion_type

Com_preload_keys

Com_prepare_sql

Com_purge

Com_purge_before_date

Com_release_savepoint

Com_rename_table

Com_rename_user

Com_repair

Com_replace

Com_replace_select

Com_reset

Com_restore_table

Com_revoke

Com_revoke_all

Com_rollback

Com_rollback_to_savepoint

Com_savepoint

Com_select

Com_set_option

Com_show_authors

Com_show_binlog_events

Com_show_binlogs

Com_show_charsets

Com_show_collations

Com_show_column_types

Com_show_contributors

Com_show_create_db

Com_show_create_event

Com_show_create_func

Com_show_create_proc

Com_show_create_table

Com_show_create_trigger

Com_show_databases

Com_show_engine_logs

Com_show_engine_mutex

Com_show_engine_status

Com_show_errors

Com_show_events

Com_show_fields

Com_show_function_status

Com_show_grants

Com_show_keys

Com_show_master_status

Com_show_new_master

Com_show_open_tables

Com_show_plugins

Com_show_privileges

Com_show_procedure_status

Com_show_processlist

Com_show_profile

Com_show_profiles

Com_show_slave_hosts

Com_show_slave_status

Com_show_status

Com_show_storage_engines

Com_show_tables

Com_show_table_status

Com_show_triggers

Com_show_variables

Com_show_warnings

Com_slave_start

Com_slave_stop

Com_stmt_close

Com_stmt_execute

Com_stmt_fetch

Com_stmt_prepare

Com_stmt_reprepare

Com_stmt_reset

Com_stmt_send_long_data

Com_truncate

Com_uninstall_plugin

Com_unlock_tables

Com_update

Com_update_multi

Com_xa_commit

Com_xa_end

Com_xa_prepare

Com_xa_recover

Com_xa_rollback

Com_xa_start

concurrent_insert

Connections

connect_timeout

Created_tmp_disk_tables

Created_tmp_files

Created_tmp_tables

default_week_format

Delayed_errors

delayed_insert_limit

Delayed_insert_threads

delayed_insert_timeout

delayed_queue_size

Delayed_writes

div_precision_increment

error_count

expire_logs_days

Flush_commands

flush_time

ft_max_word_len

ft_min_word_len

ft_query_expansion_limit

group_concat_max_len

Handler_commit

Handler_delete

Handler_discover

Handler_prepare

Handler_read_first

Handler_read_key

Handler_read_next

Handler_read_prev

Handler_read_rnd

Handler_read_rnd_next

Handler_rollback

Handler_savepoint

Handler_savepoint_rollback

Handler_update

Handler_write

identity

innodb_additional_mem_pool_size

innodb_autoextend_increment

innodb_autoinc_lock_mode

Innodb_buffer_pool_pages_data

Innodb_buffer_pool_pages_dirty

Innodb_buffer_pool_pages_flushed

Innodb_buffer_pool_pages_free

Innodb_buffer_pool_pages_misc

Innodb_buffer_pool_pages_total

Innodb_buffer_pool_read_ahead_rnd

Innodb_buffer_pool_read_ahead_seq

Innodb_buffer_pool_read_requests

Innodb_buffer_pool_reads

innodb_buffer_pool_size

Innodb_buffer_pool_wait_free

Innodb_buffer_pool_write_requests

innodb_commit_concurrency

innodb_concurrency_tickets

Innodb_data_fsyncs

Innodb_data_pending_fsyncs

Innodb_data_pending_reads

Innodb_data_pending_writes

Innodb_data_read

Innodb_data_reads

Innodb_data_writes

Innodb_data_written

Innodb_dblwr_pages_written

Innodb_dblwr_writes

innodb_fast_shutdown

innodb_file_io_threads

innodb_flush_log_at_trx_commit

innodb_force_recovery

innodb_lock_wait_timeout

innodb_log_buffer_size

innodb_log_files_in_group

innodb_log_file_size

Innodb_log_waits

Innodb_log_write_requests

Innodb_log_writes

innodb_max_dirty_pages_pct

innodb_max_purge_lag

innodb_mirrored_log_groups

Innodb_mutex_os_waits

Innodb_mutex_spin_rounds

Innodb_mutex_spin_waits

innodb_open_files

Innodb_os_log_fsyncs

Innodb_os_log_pending_fsyncs

Innodb_os_log_pending_writes

Innodb_os_log_written

Innodb_pages_created

Innodb_page_size

Innodb_pages_read

Innodb_pages_written

Innodb_row_lock_current_waits

Innodb_row_lock_time

Innodb_row_lock_time_avg

Innodb_row_lock_time_max

Innodb_row_lock_waits

Innodb_rows_deleted

Innodb_rows_inserted

Innodb_rows_read

Innodb_rows_updated

innodb_sync_spin_loops

innodb_thread_concurrency

innodb_thread_sleep_delay

insert_id

interactive_timeout

Is_slave

join_buffer_size

Key_blocks_not_flushed

Key_blocks_unused

Key_blocks_used

key_buffer_size

key_cache_age_threshold

key_cache_block_size

key_cache_division_limit

Key_read_requests

Key_reads

Key_write_requests

Key_writes

large_page_size

last_insert_id

log_warnings

lower_case_table_names

max_allowed_packet

max_binlog_size

max_connect_errors

max_connections

max_delayed_threads

max_error_count

max_heap_table_size

max_insert_delayed_threads

max_length_for_sort_data

max_long_data_size

max_prepared_stmt_count

max_relay_log_size

max_sort_length

max_sp_recursion_depth

max_tmp_tables

Max_used_connections

max_user_connections

min_examined_row_limit

multi_range_count

myisam_data_pointer_size

myisam_max_sort_file_size

myisam_repair_threads

myisam_sort_buffer_size

mysql_alive_local

net_buffer_length

net_read_timeout

net_retry_count

net_write_timeout

Not_flushed_delayed_rows

Opened_files

Opened_table_definitions

Opened_tables

Open_files

open_files_limit

Open_streams

Open_table_definitions

Open_tables

optimizer_prune_level

optimizer_search_depth

port

preload_buffer_size

Prepared_stmt_count

profiling_history_size

protocol_version

pseudo_thread_id

Qcache_free_blocks

Qcache_free_memory

Qcache_hits

Qcache_inserts

Qcache_lowmem_prunes

Qcache_not_cached

Qcache_queries_in_cache

Qcache_total_blocks

Queries

query_alloc_block_size

query_cache_limit

query_cache_min_res_unit

query_cache_size

query_prealloc_size

Questions

range_alloc_block_size

read_buffer_size

read_rnd_buffer_size

relay_log_space_limit

report_port

rpl_recovery_rank

Select_full_join

Select_full_range_join

Select_range

Select_range_check

Select_scan

server_id

slave_max_allowed_packet

slave_net_timeout

Slave_open_temp_tables

Slave_retried_transactions

slave_transaction_retries

Slow_launch_threads

slow_launch_time

Slow_queries

sort_buffer_size

Sort_merge_passes

Sort_range

Sort_rows

Sort_scan

Ssl_accept_renegotiates

Ssl_accepts

Ssl_callback_cache_hits

Ssl_client_connects

Ssl_connect_renegotiates

Ssl_ctx_verify_depth

Ssl_ctx_verify_mode

Ssl_default_timeout

Ssl_finished_accepts

Ssl_finished_connects

Ssl_session_cache_hits

Ssl_session_cache_misses

Ssl_session_cache_overflows

Ssl_session_cache_size

Ssl_session_cache_timeouts

Ssl_sessions_reused

Ssl_used_session_cache_entries

Ssl_verify_depth

Ssl_verify_mode

sync_binlog

table_definition_cache

Table_locks_immediate

Table_locks_waited

table_lock_wait_timeout

table_open_cache

Tc_log_max_pages_used

Tc_log_page_size

Tc_log_page_waits

thread_cache_size

Threads_cached

Threads_connected

Threads_created

Threads_running

thread_stack

timestamp

tmp_table_size

transaction_alloc_block_size

transaction_prealloc_size

Uptime

Uptime_since_flush_status

wait_timeout

warning_count


 
OpenFalcon 更多文章 交换机监控方案 记一次redis规模化运维讨论会(含PPT) OpenFalcon开发team在SACC上的讲稿分享 Open-Falcon发布新版本了
猜您喜欢 Web自动化框架实践指南 膝盖拿去!小白的她用短短3年居然就画成了这样! 综合指南:何时使用 Em 与 Rem 一个 App 的界面设计流程是怎么产生的? Google Develop for Android 系列(一) - 上下文(Context)介绍