Ad Widget

Collapse

Where does zabbix store its history data?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tfqzab
    Member
    • Apr 2011
    • 51

    #1

    Where does zabbix store its history data?

    Hello, my friends. I am using zabbix appliance 1.8.4. I want to select some special sets of historical monitor datas from zabbix. But I don't know where to fetch. I've connected to the mysqldatabase, it seems the history datas(for example, a interface's bandwidth datas in the past week) are not stored any database tables. So where does the history datas store? How can I select them?
    Thanks in advance!
  • MrKen
    Senior Member
    • Oct 2008
    • 652

    #2
    I can't imagine that the zabbix appliance would be any different from any other zabbix, although I could be wrong, but historical data is kept in the following tables:

    history
    history_log
    history_str
    history_str_sync
    history_sync
    history_text
    history_uint
    history_uint_sync

    MrKen
    Disclaimer: All of the above is pure speculation.

    Comment

    • tfqzab
      Member
      • Apr 2011
      • 51

      #3
      MrKen, maybe you're right. Thank you. I'll look into the details of the history tables and find the datas I want.

      Comment

      Working...