Problem Zabbix database tables history_unit,history,trends and more

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Blocker
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None

      Hi,
      We have a Zabbix software monitoring tool in our environment, and the main problem is the large size of tables of Zabbix sever database.

      Zabbix Server machine:
      zabbix-web-mysql-3.0.2-1.el7.noarch
      zabbix-release-3.0-1.el7.noarch
      zabbix-web-3.0.2-1.el7.noarch
      zabbix-agent-3.0.2-1.el7.x86_64
      zabbix-server-mysql-3.0.2-1.el7.x86_64
      zabbix-java-gateway-3.0.2-1.el7.x86_64

      Zabbix sever database(PROBLEM):
      Mysql Ver 14.14 Distrib 5.6.29, for linux-glibc2.5 (x86_64) using EditLine wrapper
      zabbix-release-3.0-1.el7.noarch
      zabbix-2.4.3-1.el7.x86_64
      zabbix-agent-2.4.3-1.el7.x86_64

      The main problem is the size of these tables.

      rw-r---- 1 mysql mysql 5,3G ago 19 12:30 trends.ibd
      rw-r---- 1 mysql mysql 2,1G ago 19 12:40 events.ibd
      rw-r---- 1 mysql mysql 6,6G ago 19 12:40 trends_uint.ibd
      rw-r---- 1 mysql mysql 5,1G ago 19 12:40 history_str.ibd
      rw-r---- 1 mysql mysql 47G ago 19 12:40 history.ibd
      rw-r---- 1 mysql mysql 124G ago 19 12:40 history_uint.ibd

      Now we are saving for each item:
      History storage period (in days) : 15
      Trend storage period (in days) : 365

      Attach screenshot of Housekeeping configuration.
      Attach configs Server Zabbix.
      Attach zabbix_server.log

      We need to clean or reduce this space as soon as possible.
      Could you help us to solve this problem?

      Our Zabbix infrastructure:

      Zabbix Server
      Hostname = zabbix(Server Service)
      IP Address = 172.X.X.161
      OS = CentOS 7.x
      CPU = 8 vCPUs
      Memory = 8 Gb
      HD = 50 Gb

      Database Server
      Hostname = zabbixdb
      IP Address = 172.X.X.162
      OS = CentOS 7.x
      CPU = 12 vCPUs
      Memory = 32 Gb
      HD = 220 Gb

      Proxies Servers (5 servers)
      Hostname = proxyzabbix01-05
      IP Address = 172.X.X.X (.184, .185, .186, .187, .188)
      OS = CentOS 7.x
      CPU = 8 vCPUs
      Memory = 8Gb
      HD = 50Gb

      If you need more information, we will send it to you.

      Regards

            Assignee:
            Unassigned
            Reporter:
            PrivaliaVP
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: