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


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

[mysqlservercommands.graph]
check_command = "Mysql-commands"


[mysqlservercommands.urlparams]
areaAlpha   = "0.2"
areaMode    = "stacked"
colorList   = "66cc88,6666cc,66ccdd,ffaa22,cc66dd"
;              ^      ^      ^
;              select insert replace update delete
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"


[mysqlservercommands.metrics_filters]
; used     = "$service_name_template$.perfdata.global-used.value"
; avail    = "$service_name_template$.perfdata.global-avail.value"
; total    = "$service_name_template$.perfdata.global-total.value"
select     = "$service_name_template$.perfdata.select.value"
insert     = "$service_name_template$.perfdata.insert.value"
replace    = "$service_name_template$.perfdata.replace.value"
update     = "$service_name_template$.perfdata.update.value"
delete     = "$service_name_template$.perfdata.delete.value"


[mysqlservercommands.functions]
select  = "alias($metric$, 'select')"
insert  = "alias($metric$, 'insert')"
replace = "alias($metric$, 'replace')"
update  = "alias($metric$, 'update')"
delete  = "alias($metric$, 'delete (all stacked)')"

; ----------------------------------------------------------------------
; PIE chart
; ----------------------------------------------------------------------

[mysqlservercommandspie.graph]
check_command = "Mysql-commands"


[mysqlservercommandspie.urlparams]
; colorList   = "6699aa,66cc88,6699aaAA,6699aa88,6699aa44,88ccdd"
colorList   = "66cc88,6666cc,66ccdd,ffaa22,cc66dd"
;              ^      ^      ^
;              select insert replace update delete
graphType = "pie"
title     = "Current mysql commands"


[mysqlservercommandspie.metrics_filters]
select     = "$service_name_template$.perfdata.select.value"
insert     = "$service_name_template$.perfdata.insert.value"
replace    = "$service_name_template$.perfdata.replace.value"
update     = "$service_name_template$.perfdata.update.value"
delete     = "$service_name_template$.perfdata.delete.value"

[mysqlservercommandspie.functions]
select  = "alias($metric$, 'select')"
insert  = "alias($metric$, 'insert')"
replace = "alias($metric$, 'replace')"
update  = "alias($metric$, 'update')"
delete  = "alias($metric$, 'delete')"