Bulk inserts in history

[maurochss]

Dear all,

I have an sql query that i should run every 1 minute to determine number of transactions per minute, but to avoid stressing the database i would like to run and generate an output to a file grouped by minute every 1 hour. Then i would have a script that will run this file line by line and then send the data to the zabbix server now my dilemma is.

If i use zabbix_sender i will not be able to upload data per minute there fore i am left to do direct inserts on zabbix database to which databases should i perform the inserts. Or is there any way to tell zabbix_sender to send the data for a specific time?

Regards,
MauroChSS

[richlv]

in 1.8, zabbix_sender supports timestamps when sending from an input file (note, hostnames with spaces do not work from the input file)

[maurochss]

Dear Richlv,

Thanks for the reply. it worked.

PS: I am using 1.6 and the timestamp feature is there.

Regards.

in 1.8, zabbix_sender supports timestamps when sending from an input file (note, hostnames with spaces do not work from the input file)