item prototype values

[sudo092]

I have an item prototype (MySQL connections) on a custom made template. It returns values for multiple MySQL instances on the same server using LLD.

On the latest data tab, the values for these instances is just a count and increments each time new connections are made. It never drops or fluctuates, which is what i would expect.

How would i go about calculating a "real time" value? Do i do it with item pre-processing?

[splitek]

If the "item" returns not what you expected, you probably did something wrong. But maybe you just need calculated item. See here:

https://www.zabbix.com/documentation/4.0/manual/config/items/itemtypes/calculated

[sudo092]

Thanks for your input but i figured out what i needed to do from another template.

When zabbix server receives metric data from the agent via the following user parameter...

UserParameter=multi.connections[*],mysqladmin --defaults-file=/path/to/zabbix.cnf -h $1 -P $2 extended-status | grep Connections | cut -f3 -d"|"

...the value that is returned equates to the total number of connections since the mysqld instance started up (Which can be days, weeks, months ago).

This value was not what i wanted.

So i added the "change per second" step within the item prototype "pre-processing" tab.

"Evaluated as (value-prev_value)/(time-prev_time)" - https://www.zabbix.com/documentation..._preprocessing