; ======================================================================
;
;   MYSQLSERVER connects
;
; ----------------------------------------------------------------------
; 2020-09-10  <axel.hahn@iml.unibe.ch>  initial version
; ======================================================================


; ----------------------------------------------------------------------
; graph
; ----------------------------------------------------------------------

[mysqlserver-qcache-hits.graph]
check_command = "Mysql-qcache-hits"

; connections=13.33333333333333333333;;;0; abortedclients=0;;;0; abortedconnects=0;;;0;

[mysqlserver-qcache-hits.urlparams]
areaAlpha   = "0.2"
areaMode    = "stacked"
colorList   = "66cc88,cc66dd,d0d8da"
;              ^      ^      ^
;              hits   insert uncached
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"


[mysqlserver-qcache-hits.metrics_filters]
hits       = "$service_name_template$.perfdata.hits.value"
inserts    = "$service_name_template$.perfdata.inserts.value"
notcached  = "$service_name_template$.perfdata.notcached.value"

[mysqlserver-qcache-hits.functions]
hits       = "alias($metric$, 'Hits')"
inserts    = "alias($metric$, 'Inserts')"
notcached  = "alias($metric$, 'Not cached (stacked)')"


; ----------------------------------------------------------------------
; pie
; ----------------------------------------------------------------------

[mysqlserver-qcache-hits-pie.graph]
check_command = "Mysql-qcache-hits"

; connections=13.33333333333333333333;;;0; abortedclients=0;;;0; abortedconnects=0;;;0;

[mysqlserver-qcache-hits-pie.urlparams]

colorList   = "66cc88,cc66dd,d0d8da"
;              ^      ^      ^
;              hits   insert uncached
graphType = "pie"
title     = "Cach hits and misses"

[mysqlserver-qcache-hits-pie.metrics_filters]
hits       = "$service_name_template$.perfdata.hits.value"
inserts    = "$service_name_template$.perfdata.inserts.value"
notcached  = "$service_name_template$.perfdata.notcached.value"

[mysqlserver-qcache-hits-pie.functions]
hits       = "alias($metric$, 'Hits')"
inserts    = "alias($metric$, 'Inserts')"
notcached  = "alias($metric$, 'Not cached (stacked values)')"