Ad Widget

Collapse

Zabbix trapper items, injecting multiple times

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • assie
    Junior Member
    • Apr 2011
    • 17

    #1

    Zabbix trapper items, injecting multiple times

    Hi all,

    I have configured several trapper items, and I use zabbix_sender to inject data.

    What I want to know is, what happens if you inject a big chunk of data, with the SAME epoch timestamp, several times?

    Will it all be kept in MySQL double? Will the new values overwrite the old one and will the houisekeeper delete them?

    I want to schedule a Perl script that parses a file several times and I dont want MySQL to get bloated.

    Thanks.
  • Pada
    Senior Member
    • Apr 2012
    • 236

    #2
    Only one of the values will be stored in the database, because the history tables have a unique index over the itemid and clock columns, meaning that for a specific second in time, there can only be 1 value for that particular item.

    Unfortunately I cannot comment on whether the first or last value will be used. It should be easy to test...

    Comment

    • assie
      Junior Member
      • Apr 2011
      • 17

      #3
      Originally posted by Pada
      Only one of the values will be stored in the database, because the history tables have a unique index over the itemid and clock columns, meaning that for a specific second in time, there can only be 1 value for that particular item.

      Unfortunately I cannot comment on whether the first or last value will be used. It should be easy to test...
      I appriciate the comment, but that was really a given. Its the stuff Zabbix does with the 'redundant' or 'old' values..

      Thanks anyways

      Comment

      Working...