1 files changed, 456 insertions, 0 deletions
diff --git a/templates/mysql_health.ini b/templates/mysql_health.ini
new file mode 100644
index 0000000..711338c
--- /dev/null
+++ b/templates/mysql_health.ini
@@ -0,0 +1,456 @@
+[mysql_health-bufferpool_hitrate.graph]
+check_command = "mysql_health"
+
+[mysql_health-bufferpool_hitrate.metrics_filters]
+value = "$service_name_template$.perfdata.bufferpool_hitrate.value"
+now.value = "$service_name_template$.perfdata.bufferpool_hitrate_now.value"
+
+[mysql_health-bufferpool_hitrate.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-bufferpool_hitrate.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'InnoDB buffer pool hitrate (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'InnoDB buffer pool hitrate (now, %)')"
+
+
+[mysql_health-bufferpool_wait_free.graph]
+check_command = "mysql_health"
+
+[mysql_health-bufferpool_wait_free.metrics_filters]
+value = "$service_name_template$.perfdata.bufferpool_free_waits_rate.value"
+
+[mysql_health-bufferpool_wait_free.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-bufferpool_wait_free.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'InnoDB buffer pool waits/s')"
+
+
+[mysql_health-clients_aborted.graph]
+check_command = "mysql_health"
+
+[mysql_health-clients_aborted.metrics_filters]
+value = "$service_name_template$.perfdata.clients_aborted_per_sec.value"
+
+[mysql_health-clients_aborted.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-clients_aborted.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Clients aborted/s')"
+
+
+[mysql_health-cluster_ndbd_running.graph]
+check_command = "mysql_health"
+
+[mysql_health-cluster_ndbd_running.metrics_filters]
+ndbd_nodes.value = "$service_name_template$.perfdata.ndbd_nodes.value"
+ndb_mgmd_nodes.value = "$service_name_template$.perfdata.ndb_mgmd_nodes.value"
+
+[mysql_health-cluster_ndbd_running.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-cluster_ndbd_running.functions]
+ndbd_nodes.value = "alias(color($metric$, '#1a7dd7'), 'Ndbd nodes')"
+ndb_mgmd_nodes.value = "alias(color($metric$, '#ff5566'), 'Ndb_mgmd nodes')"
+
+
+[mysql_health-mysqld_nodes.graph]
+check_command = "mysql_health"
+
+[mysql_health-mysqld_nodes.metrics_filters]
+value = "$service_name_template$.perfdata.mysqld_nodes.value"
+
+[mysql_health-mysqld_nodes.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-mysqld_nodes.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'MySQLd nodes')"
+
+
+[mysql_health-connection_time.graph]
+check_command = "mysql_health"
+
+[mysql_health-connection_time.metrics_filters]
+value = "$service_name_template$.perfdata.connection_time.value"
+
+[mysql_health-connection_time.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-connection_time.functions]
+value = "alias(color(scale($metric$, 1000), '#1a7dd7'), 'Connection time (ms)')"
+
+
+[mysql_health-connects_aborted.graph]
+check_command = "mysql_health"
+
+[mysql_health-connects_aborted.metrics_filters]
+value = "$service_name_template$.perfdata.connects_aborted_per_sec.value"
+
+[mysql_health-connects_aborted.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-connects_aborted.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Connects aborted/s')"
+
+
+[mysql_health-index_usage.graph]
+check_command = "mysql_health"
+
+[mysql_health-index_usage.metrics_filters]
+value = "$service_name_template$.perfdata.index_usage.value"
+now.value = "$service_name_template$.perfdata.index_usage_now.value"
+
+[mysql_health-index_usage.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-index_usage.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Index usage (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'Index usage (now, %)')"
+
+
+[mysql_health-keycache_hitrate.graph]
+check_command = "mysql_health"
+
+[mysql_health-keycache_hitrate.metrics_filters]
+value = "$service_name_template$.perfdata.keycache_hitrate.value"
+now.value = "$service_name_template$.perfdata.keycache_hitrate_now.value"
+
+[mysql_health-keycache_hitrate.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-keycache_hitrate.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'MyISAM keycache hitrate (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'MyISAM keycache hitrate (now, %)')"
+
+
+[mysql_health-log_waits.graph]
+check_command = "mysql_health"
+
+[mysql_health-log_waits.metrics_filters]
+value = "$service_name_template$.perfdata.innodb_log_waits_rate.value"
+
+[mysql_health-log_waits.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-log_waits.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'InnoDB log waits/s')"
+
+
+[mysql_health-long_running_procs.graph]
+check_command = "mysql_health"
+
+[mysql_health-long_running_procs.metrics_filters]
+value = "$service_name_template$.perfdata.long_running_procs.value"
+
+[mysql_health-long_running_procs.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-long_running_procs.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Long running processes')"
+
+
+[mysql_health-open_files.graph]
+check_command = "mysql_health"
+
+[mysql_health-open_files.metrics_filters]
+value = "$service_name_template$.perfdata.open_files.value"
+
+[mysql_health-open_files.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-open_files.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Open files')"
+
+
+[mysql_health-qcache_hitrate.graph]
+check_command = "mysql_health"
+
+[mysql_health-qcache_hitrate.metrics_filters]
+value = "$service_name_template$.perfdata.qcache_hitrate.value"
+now.value = "$service_name_template$.perfdata.qcache_hitrate_now.value"
+
+[mysql_health-qcache_hitrate.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-qcache_hitrate.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Query cache hitrate (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'Query cache hitrate (now, %)')"
+
+
+[mysql_health-selects_per_sec.graph]
+check_command = "mysql_health"
+
+[mysql_health-selects_per_sec.metrics_filters]
+value = "$service_name_template$.perfdata.selects_per_sec.value"
+
+[mysql_health-selects_per_sec.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-selects_per_sec.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Selects/s')"
+
+
+[mysql_health-qcache_lowmem_prunes.graph]
+check_command = "mysql_health"
+
+[mysql_health-qcache_lowmem_prunes.metrics_filters]
+value = "$service_name_template$.perfdata.qcache_lowmem_prunes_rate.value"
+
+[mysql_health-qcache_lowmem_prunes.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-qcache_lowmem_prunes.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Query cache lowmem prunes/s')"
+
+
+[mysql_health-slave_lag.graph]
+check_command = "mysql_health"
+
+[mysql_health-slave_lag.metrics_filters]
+value = "$service_name_template$.perfdata.slave_lag.value"
+
+[mysql_health-slave_lag.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "sec"
+
+[mysql_health-slave_lag.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Seconds slave is behind master')"
+
+
+[mysql_health-slow_queries.graph]
+check_command = "mysql_health"
+
+[mysql_health-slow_queries.metrics_filters]
+value = "$service_name_template$.perfdata.slow_queries_rate.value"
+
+[mysql_health-slow_queries.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-slow_queries.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Slow queries/s')"
+
+
+[mysql_health-table_lock_contention.graph]
+check_command = "mysql_health"
+
+[mysql_health-table_lock_contention.metrics_filters]
+value = "$service_name_template$.perfdata.tablelock_contention.value"
+now.value = "$service_name_template$.perfdata.tablelock_contention_now.value"
+
+[mysql_health-table_lock_contention.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-table_lock_contention.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Table lock contention (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'Table lock contention (now, %)')"
+
+
+[mysql_health-tablecache_hitrate.graph]
+check_command = "mysql_health"
+
+[mysql_health-tablecache_hitrate.metrics_filters]
+value = "$service_name_template$.perfdata.tablecache_hitrate.value"
+
+[mysql_health-tablecache_hitrate.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-tablecache_hitrate.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Table cache hitrate (%)')"
+
+
+[mysql_health-tablecache_fillrate.graph]
+check_command = "mysql_health"
+
+[mysql_health-tablecache_fillrate.metrics_filters]
+value = "$service_name_template$.perfdata.tablecache_fillrate.value"
+
+[mysql_health-tablecache_fillrate.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-tablecache_fillrate.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Table cache fillrate (%)')"
+
+
+[mysql_health-threadcache_hitrate.graph]
+check_command = "mysql_health"
+
+[mysql_health-threadcache_hitrate.metrics_filters]
+value = "$service_name_template$.perfdata.thread_cache_hitrate.value"
+now.value = "$service_name_template$.perfdata.thread_cache_hitrate_now.value"
+
+[mysql_health-threadcache_hitrate.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-threadcache_hitrate.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Thread cache hitrate (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'Thread cache hitrate (now, %)')"
+
+
+[mysql_health-threads_cached.graph]
+check_command = "mysql_health"
+
+[mysql_health-threads_cached.metrics_filters]
+value = "$service_name_template$.perfdata.threads_cached.value"
+
+[mysql_health-threads_cached.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-threads_cached.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Threads cached')"
+
+
+[mysql_health-threads_connected.graph]
+check_command = "mysql_health"
+
+[mysql_health-threads_connected.metrics_filters]
+value = "$service_name_template$.perfdata.threads_connected.value"
+
+[mysql_health-threads_connected.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-threads_connected.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Threads connected')"
+
+
+[mysql_health-threads_created.graph]
+check_command = "mysql_health"
+
+[mysql_health-threads_created.metrics_filters]
+value = "$service_name_template$.perfdata.threads_created_per_sec.value"
+
+[mysql_health-threads_created.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-threads_created.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Threads created/s')"
+
+
+[mysql_health-threads_running.graph]
+check_command = "mysql_health"
+
+[mysql_health-threads_running.metrics_filters]
+value = "$service_name_template$.perfdata.threads_running.value"
+
+[mysql_health-threads_running.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-threads_running.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Threads running')"
+
+
+[mysql_health-tmp_disk_tables.graph]
+check_command = "mysql_health"
+
+[mysql_health-tmp_disk_tables.metrics_filters]
+value = "$service_name_template$.perfdata.pct_tmp_table_on_disk.value"
+now.value = "$service_name_template$.perfdata.pct_tmp_table_on_disk_now.value"
+
+[mysql_health-tmp_disk_tables.urlparams]
+areaAlpha = "0.5"
+areaMode = "first"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql_health-tmp_disk_tables.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Temp tables created on disk (%)')"
+now.value = "alias(color($metric$, '#ff5566'), 'Temp tables created on disk (now, %)')"