Zabbix - MySQL Connections Graph

Hi all.
I have propertly installed zabbix and Percona Monitor Plugin on one MySQL Server.
All data are corect collected i think.

But i have one litle question. On Graph below
you can see Blue line “Connections”. What this data mean? In MySQL documentation i can read that this value say how many connections was opened and aborted from MySQL server start.
On this graph i see that vale is equal 0 with peaks every 5 minuts.

It is normal?
If this value show “show status like ‘Connections’;” then something is wrong. On my server is this value is 500k+ (i check form command line), but graph say it’s 0.

P.S. Sorry for my english :slight_smile:

“Connections” is dynamic status variable and shows the current number of connection attempts to MySQL.

Per http://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html
[LIST]
[*]300 sec. polling interval - like with Cacti, the existing PHP script is used to retrive and cache MySQL metrics except some trigger-specific items. Due to the caching of results, PHP script runs only once per period.
[/LIST]
So it looks like this graph didn’t make a flat line between each 5 min. tick from X axis averaging the value to 300. Strange… as other lines are ok.

Finaly, i found the reson.
In zabbix template i change perion to 30s (from 300s).
In script /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh in line 29 on agent we can find
if [ expr $TIMENOW - $TIMEFLM -gt 300 ]; then
This script create cache file on agent host and even i change period in Template, agent send me data from cach file.
Thats why agent send me new value of variable Connections evry 5 minuts and other request are eqal 0.

Great :slight_smile: