# Zabbix - MySQL Connections Graph

**URL:** <https://forums.percona.com/t/zabbix-mysql-connections-graph/4039>\
**Category:** Percona Monitoring Plugins\
**Created:** [February 3, 2015, 6:19am UTC](https://forums.percona.com/t/zabbix-mysql-connections-graph/4039 "2015-02-03T06:19:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![r3b3l](https://avatars.discourse-cdn.com/v4/letter/r/ec9cab/32.png) [@r3b3l](https://forums.percona.com/u/r3b3l)\
**Post date:** [February 3, 2015, 6:19am UTC](https://forums.percona.com/t/zabbix-mysql-connections-graph/4039/1 "2015-02-03T06:19:53Z")

</div>

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 🙂

![photoid=31413](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/81a3363a405009222e88c667b6f0d626e029c418.jpeg)

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [February 3, 2015, 2:07pm UTC](https://forums.percona.com/t/zabbix-mysql-connections-graph/4039/2 "2015-02-03T14:07:04Z")

</div>

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

Per [url][Percona Monitoring Plugins](http://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html%5B/url%5D)  
[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.

---

<div class="post-metadata">

**Author:** ![r3b3l](https://avatars.discourse-cdn.com/v4/letter/r/ec9cab/32.png) [@r3b3l](https://forums.percona.com/u/r3b3l)\
**Post date:** [February 4, 2015, 3:21am UTC](https://forums.percona.com/t/zabbix-mysql-connections-graph/4039/3 "2015-02-04T03:21:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [February 4, 2015, 5:00am UTC](https://forums.percona.com/t/zabbix-mysql-connections-graph/4039/4 "2015-02-04T05:00:58Z")

</div>

Great 🙂