I've been given the task to monitor a specific value in some MySQL server database, I need to raise a notification if the value has not been changed in the last 10 minutes.
I've added to the
UserParameter_mysql.conf the following line:
UserParameter=mysql.query, echo "select id from resolved_clicks order by id desc limit 1" | mysql -N -u zabbix -pPASSWORD aggregator
And when running a check from the Zabbix server, it returns the value correctly:
[root@zabbix ~]# zabbix_get -s IP -k mysql.query 7957178672 [root@zabbix ~]#
The next step was to create an Item which I've already done so and now I'm trying to configure the Trigger. The trigger should arise a notification if the value has not been updated in the last 10 minutes. How can I configure the trigger to reflect this condition? Thanks!
Edit #1: Here's the Latest data from the trigger I've just created: My questions are:
1. What's the meaning of change? 2. How can I know from looking on the Change row how many seconds have passed since the last 2 checks? 3. How can I test that the trigger is operating successfully without having to reproduce the problem?