Created
December 22, 2014 02:35
-
-
Save n0ts/8d56c02195590a7609d4 to your computer and use it in GitHub Desktop.
Ganglia MySQL Configuration
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### | |
### | |
### This module requires MySQL-python e.g. on Centos/RHEL | |
### * yum install MySQL-python | |
### | |
### Note: | |
### To setup database access: | |
### GRANT SUPER, PROCESS ON *.* TO your_user@localhost \ | |
### IDENTIFIED BY "your_password"; | |
### | |
### Notice in this example binlogging is not enabled in the MySQL | |
### server. In this case the "mysql_binlog_*" metrics are | |
### commented out. | |
### | |
modules { | |
module { | |
name = "mysql" | |
language = "python" | |
param host { | |
value = '127.0.0.1' | |
} | |
param user { | |
value = 'foo' | |
} | |
param passwd { | |
value = 'bar' | |
} | |
param port { | |
value = 3306 | |
} | |
param socket { | |
value = '/var/lib/mysql/mysql.sock' | |
} | |
param timeout { | |
value = 1 | |
} | |
param get_innodb { | |
value = True | |
} | |
param get_master { | |
value = False | |
} | |
param get_slave { | |
value = True | |
} | |
} | |
} | |
collection_group { | |
collect_every = 60 | |
time_threshold = 60 | |
metric { | |
name = "mysql_innodb_pending_normal_aio_reads" | |
} | |
metric { | |
name = "mysql_innodb_pending_log_writes" | |
} | |
metric { | |
name = "mysql_innodb_transactions" | |
} | |
metric { | |
name = "mysql_innodb_pending_chkp_writes" | |
} | |
metric { | |
name = "mysql_innodb_rows_updated" | |
} | |
metric { | |
name = "mysql_innodb_data_fsyncs" | |
} | |
metric { | |
name = "mysql_innodb_spin_rounds" | |
} | |
metric { | |
name = "mysql_innodb_spin_waits" | |
} | |
metric { | |
name = "mysql_innodb_pending_aio_log_ios" | |
} | |
metric { | |
name = "mysql_innodb_pending_log_flushes" | |
} | |
metric { | |
name = "mysql_innodb_rows_read" | |
} | |
metric { | |
name = "mysql_innodb_transactions_unpurged" | |
} | |
metric { | |
name = "mysql_innodb_queries_queued" | |
} | |
metric { | |
name = "mysql_innodb_pending_ibuf_aio_reads" | |
} | |
metric { | |
name = "mysql_innodb_pending_normal_aio_writes" | |
} | |
metric { | |
name = "mysql_innodb_pages_read" | |
} | |
metric { | |
name = "mysql_innodb_read_views" | |
} | |
metric { | |
name = "mysql_innodb_buffer_pool_pages_data" | |
} | |
metric { | |
name = "mysql_innodb_data_reads" | |
} | |
metric { | |
name = "mysql_innodb_queries_inside" | |
} | |
metric { | |
name = "mysql_innodb_log_bytes_written" | |
} | |
metric { | |
name = "mysql_innodb_buffer_pool_pages_dirty" | |
} | |
metric { | |
name = "mysql_innodb_pending_aio_sync_ios" | |
} | |
metric { | |
name = "mysql_innodb_ibuf_merged" | |
} | |
metric { | |
name = "mysql_innodb_pages_created" | |
} | |
metric { | |
name = "mysql_innodb_buffer_pool_pages_free" | |
} | |
metric { | |
name = "mysql_innodb_pages_written" | |
} | |
metric { | |
name = "mysql_innodb_rows_inserted" | |
} | |
metric { | |
name = "mysql_innodb_active_transactions" | |
} | |
metric { | |
name = "mysql_innodb_log_bytes_flushed" | |
} | |
metric { | |
name = "mysql_innodb_history_list" | |
} | |
metric { | |
name = "mysql_innodb_pending_buffer_pool_flushes" | |
} | |
metric { | |
name = "mysql_innodb_current_transactions" | |
} | |
metric { | |
name = "mysql_innodb_ibuf_inserts" | |
} | |
metric { | |
name = "mysql_innodb_rows_deleted" | |
} | |
metric { | |
name = "mysql_innodb_buffer_pool_pages_total" | |
} | |
metric { | |
name = "mysql_innodb_log_bytes_unflushed" | |
} | |
metric { | |
name = "mysql_innodb_data_writes" | |
} | |
metric { | |
name = "mysql_innodb_transactions_purged" | |
} | |
metric { | |
name = "mysql_innodb_os_waits" | |
} | |
metric { | |
name = "mysql_innodb_log_writes" | |
} | |
metric { | |
name = "mysql_innodb_ibuf_merges" | |
} | |
/* | |
metric { | |
name = "mysql_binlog_space_used" | |
} | |
metric { | |
name = "mysql_binlog_space_current" | |
} | |
metric { | |
name = "mysql_binlog_count" | |
} | |
metric { | |
name = "mysql_binlog_space_total" | |
} | |
*/ | |
metric { | |
name = "mysql_key_write_requests" | |
} | |
metric { | |
name = "mysql_qcache_inserts" | |
} | |
metric { | |
name = "mysql_select_scan" | |
} | |
metric { | |
name = "mysql_key_writes" | |
} | |
metric { | |
name = "mysql_com_update_multi" | |
} | |
metric { | |
name = "mysql_table_locks_immediate" | |
} | |
metric { | |
name = "mysql_threads_created" | |
} | |
metric { | |
name = "mysql_connections" | |
} | |
metric { | |
name = "mysql_questions" | |
} | |
metric { | |
name = "mysql_bytes_received" | |
} | |
metric { | |
name = "mysql_qcache_queries_in_cache" | |
} | |
metric { | |
name = "mysql_binlog_cache_disk_use" | |
} | |
metric { | |
name = "mysql_uptime" | |
} | |
metric { | |
name = "mysql_slave_open_temp_tables" | |
} | |
metric { | |
name = "mysql_slow_launch_threads" | |
} | |
metric { | |
name = "mysql_open_tables" | |
} | |
metric { | |
name = "mysql_sort_range" | |
} | |
metric { | |
name = "mysql_select_range" | |
} | |
metric { | |
name = "mysql_com_insert" | |
} | |
metric { | |
name = "mysql_sort_rows" | |
} | |
metric { | |
name = "mysql_select_range_check" | |
} | |
metric { | |
name = "mysql_version" | |
} | |
metric { | |
name = "mysql_max_connections" | |
} | |
metric { | |
name = "mysql_query_cache_size" | |
} | |
metric { | |
name = "mysql_opened_tables" | |
} | |
metric { | |
name = "mysql_threads_running" | |
} | |
metric { | |
name = "mysql_slow_queries" | |
} | |
metric { | |
name = "mysql_created_tmp_tables" | |
} | |
metric { | |
name = "mysql_threads_connected" | |
} | |
metric { | |
name = "mysql_select_full_join" | |
} | |
metric { | |
name = "mysql_com_select" | |
} | |
metric { | |
name = "mysql_slave_retried_transactions" | |
} | |
metric { | |
name = "mysql_threads_cached" | |
} | |
metric { | |
name = "mysql_table_locks_waited" | |
} | |
metric { | |
name = "mysql_qcache_lowmem_prunes" | |
} | |
metric { | |
name = "mysql_binlog_cache_use" | |
} | |
metric { | |
name = "mysql_com_insert_select" | |
} | |
metric { | |
name = "mysql_qcache_hits" | |
} | |
metric { | |
name = "mysql_created_tmp_files" | |
} | |
metric { | |
name = "mysql_open_files" | |
} | |
metric { | |
name = "mysql_com_update" | |
} | |
metric { | |
name = "mysql_select_full_range_join" | |
} | |
metric { | |
name = "mysql_qcache_not_cached" | |
} | |
metric { | |
name = "mysql_sort_scan" | |
} | |
metric { | |
name = "mysql_max_used_connections" | |
} | |
metric { | |
name = "mysql_com_delete_multi" | |
} | |
metric { | |
name = "mysql_bytes_sent" | |
} | |
metric { | |
name = "mysql_com_replace" | |
} | |
metric { | |
name = "mysql_qcache_free_memory" | |
} | |
metric { | |
name = "mysql_qcache_total_blocks" | |
} | |
metric { | |
name = "mysql_com_delete" | |
} | |
metric { | |
name = "mysql_key_read_requests" | |
} | |
metric { | |
name = "mysql_qcache_free_blocks" | |
} | |
metric { | |
name = "mysql_aborted_connects" | |
} | |
metric { | |
name = "mysql_com_load" | |
} | |
metric { | |
name = "mysql_com_replace_select" | |
} | |
metric { | |
name = "mysql_created_tmp_disk_tables" | |
} | |
metric { | |
name = "mysql_key_reads" | |
} | |
metric { | |
name = "mysql_aborted_clients" | |
} | |
} | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment