Monitoring a database table

[Eithco]

I need to monitor a certain field in a database.

For example if my table name is 'action' and I have a field called 'response_time' I want to monitor it whenever a new row is created.

Here's what I tried:

I created Item of Type Database monitor, and added a query: select RESPONSE_TIME from dbname.action order by action_timestamp desc limit 1;

I selected "none" in the application dropbox, left the default interval on 50, and saved the item.

The database I'm hoping to monitor is in mysql on the same server machine zabbix is running on.

Would this work? Where in the GUI do I look to see the results on the monitoring?

I'm new to this so step by step instructions would be great.

Thanks for your help!

[Eithco]

UPDATE: The item in the host's list of items now have "Not Supported" listed next to it.

[Colttt]

hello you can query you database with unixodbc, and then you can use count and make a trigger with diff()

[kloczek]

I need to monitor a certain field in a database.

For example if my table name is 'action' and I have a field called 'response_time' I want to monitor it whenever a new row is created.

Here's what I tried:

I created Item of Type Database monitor, and added a query: select RESPONSE_TIME from dbname.action order by action_timestamp desc limit 1;

You can use key:

system.run[/usr/bin/mysql -sN -e "select RESPONSE_TIME from dbname.action order by action_timestamp desc limit 1;",]

To use system.run[] you need to enable on agent setup EnableRemoteCommands=1.
As well you need to provide read access without pwd from localhost for zabbix user or if it is mysql >= 5.6 you can create on mysql engine side allowing access to such data (using mysql_config_editor command)