summaryrefslogtreecommitdiffstats
path: root/templates/mysql.ini
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--templates/mysql.ini270
1 files changed, 270 insertions, 0 deletions
diff --git a/templates/mysql.ini b/templates/mysql.ini
new file mode 100644
index 0000000..f39d15a
--- /dev/null
+++ b/templates/mysql.ini
@@ -0,0 +1,270 @@
+[mysql-Connections.graph]
+check_command = "mysql"
+
+[mysql-Connections.metrics_filters]
+value = "$service_name_template$.perfdata.Connections.value"
+
+[mysql-Connections.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Connections.functions]
+value = "alias(color(nonNegativeDerivative($metric$), '#1a7dd7'), 'Connections')"
+
+
+[mysql-Open_files.graph]
+check_command = "mysql"
+
+[mysql-Open_files.metrics_filters]
+value = "$service_name_template$.perfdata.Open_files.value"
+
+[mysql-Open_files.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Open_files.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Open files')"
+
+
+[mysql-Open_tables.graph]
+check_command = "mysql"
+
+[mysql-Open_tables.metrics_filters]
+value = "$service_name_template$.perfdata.Open_tables.value"
+
+[mysql-Open_tables.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Open_tables.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Open tables')"
+
+
+[mysql-Qcache_free_memory.graph]
+check_command = "mysql"
+
+[mysql-Qcache_free_memory.metrics_filters]
+value = "$service_name_template$.perfdata.Qcache_free_memory.value"
+
+[mysql-Qcache_free_memory.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "binary"
+
+[mysql-Qcache_free_memory.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Query cache free memory (Bytes)')"
+
+
+[mysql-Qcache_hits.graph]
+check_command = "mysql"
+
+[mysql-Qcache_hits.metrics_filters]
+value = "$service_name_template$.perfdata.Qcache_hits.value"
+
+[mysql-Qcache_hits.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Qcache_hits.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Query cache hits')"
+
+
+[mysql-Qcache_inserts.graph]
+check_command = "mysql"
+
+[mysql-Qcache_inserts.metrics_filters]
+value = "$service_name_template$.perfdata.Qcache_inserts.value"
+
+[mysql-Qcache_inserts.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Qcache_inserts.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Query cache inserts')"
+
+
+[mysql-Qcache_lowmem_prunes.graph]
+check_command = "mysql"
+
+[mysql-Qcache_lowmem_prunes.metrics_filters]
+value = "$service_name_template$.perfdata.Qcache_lowmem_prunes.value"
+
+[mysql-Qcache_lowmem_prunes.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Qcache_lowmem_prunes.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Query cache lowmem prunes')"
+
+
+[mysql-Qcache_not_cached.graph]
+check_command = "mysql"
+
+[mysql-Qcache_not_cached.metrics_filters]
+value = "$service_name_template$.perfdata.Qcache_not_cached.value"
+
+[mysql-Qcache_not_cached.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Qcache_not_cached.functions]
+value = "alias(color(nonNegativeDerivative($metric$), '#1a7dd7'), 'Not cached queries')"
+
+
+[mysql-Qcache_queries_in_cache.graph]
+check_command = "mysql"
+
+[mysql-Qcache_queries_in_cache.metrics_filters]
+value = "$service_name_template$.perfdata.Qcache_queries_in_cache.value"
+
+[mysql-Qcache_queries_in_cache.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Qcache_queries_in_cache.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Queries in cache')"
+
+
+[mysql-Queries.graph]
+check_command = "mysql"
+
+[mysql-Queries.metrics_filters]
+value = "$service_name_template$.perfdata.Queries.value"
+
+[mysql-Queries.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Queries.functions]
+value = "alias(color(nonNegativeDerivative($metric$), '#1a7dd7'), 'Queries')"
+
+
+[mysql-Questions.graph]
+check_command = "mysql"
+
+[mysql-Questions.metrics_filters]
+value = "$service_name_template$.perfdata.Questions.value"
+
+[mysql-Questions.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Questions.functions]
+value = "alias(color(nonNegativeDerivative($metric$), '#1a7dd7'), 'Questions')"
+
+
+[mysql-Table_locks_waited.graph]
+check_command = "mysql"
+
+[mysql-Table_locks_waited.metrics_filters]
+value = "$service_name_template$.perfdata.Table_locks_waited.value"
+
+[mysql-Table_locks_waited.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Table_locks_waited.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Table locks waited for')"
+
+
+[mysql-Threads_connected.graph]
+check_command = "mysql"
+
+[mysql-Threads_connected.metrics_filters]
+value = "$service_name_template$.perfdata.Threads_connected.value"
+
+[mysql-Threads_connected.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Threads_connected.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Threads connected')"
+
+
+[mysql-Threads_running.graph]
+check_command = "mysql"
+
+[mysql-Threads_running.metrics_filters]
+value = "$service_name_template$.perfdata.Threads_running.value"
+
+[mysql-Threads_running.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "none"
+
+[mysql-Threads_running.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Threads running')"
+
+
+[mysql-Uptime.graph]
+check_command = "mysql"
+
+[mysql-Uptime.metrics_filters]
+value = "$service_name_template$.perfdata.Uptime.value"
+
+[mysql-Uptime.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "sec"
+
+[mysql-Uptime.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Uptime (s)')"
+
+
+[mysql-seconds_behind_master.graph]
+check_command = "mysql"
+
+[mysql-seconds_behind_master.metrics_filters]
+value = "$service_name_template$.perfdata.seconds_behind_master.value"
+
+[mysql-seconds_behind_master.urlparams]
+areaAlpha = "0.5"
+areaMode = "all"
+lineWidth = "2"
+min = "0"
+yUnitSystem = "sec"
+
+[mysql-seconds_behind_master.functions]
+value = "alias(color($metric$, '#1a7dd7'), 'Seconds behind master')"