X-Git-Url: https://arthur.barton.de/gitweb/?a=blobdiff_plain;f=charts.d%2Fmysql.chart.sh;fp=charts.d%2Fmysql.chart.sh;h=fe07658eaac2f051e9f732f91e50326e3f6c5af3;hb=a1e558d213614019886ddd8fa7dd532811df588c;hp=29d8b61bce6a73bfffdfeaa506b50d8635edf1a4;hpb=951fc1e459c055a185f766870490a71f332426f8;p=netdata.git diff --git a/charts.d/mysql.chart.sh b/charts.d/mysql.chart.sh index 29d8b61b..fe07658e 100755 --- a/charts.d/mysql.chart.sh +++ b/charts.d/mysql.chart.sh @@ -17,7 +17,7 @@ mysql_get() { local oIFS="${IFS}" mysql_data=() IFS=$'\t'$'\n' - arr=($("${@}" -e "SHOW GLOBAL STATUS WHERE value REGEXP '^[0-9]';" | egrep "^(Bytes|Slow_|Queri|Handl|Table|Selec|Sort_|Creat|Conne|Abort|Binlo|Threa|Innod|Qcach|Key_|Open)" )) + arr=($("${@}" -e "SHOW GLOBAL STATUS WHERE value REGEXP '^[0-9]';" | egrep "^(Bytes|Slow_|Que|Handl|Table|Selec|Sort_|Creat|Conne|Abort|Binlo|Threa|Innod|Qcach|Key_|Open)" )) IFS="${oIFS}" [ "${#arr[@]}" -lt 3 ] && return 1 @@ -449,7 +449,7 @@ END BEGIN mysql_$x.qcache_ops $1 SET Qcache_hits hits = ${mysql_data[Qcache_hits]} SET Qcache_lowmem_prunes = ${mysql_data[Qcache_lowmem_prunes]} -SET Qcache_inserts_inserts = ${mysql_data[Qcache_inserts_inserts]} +SET Qcache_inserts = ${mysql_data[Qcache_inserts]} SET Qcache_not_cached = ${mysql_data[Qcache_not_cached]} END BEGIN mysql_$x.qcache $1