Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  2. ZBX-6118

Very low performance changing template linked with many hosts


    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Critical Critical
    • 3.4.8rc1, 4.0.0alpha4, 4.0 (plan)
    • 2.0.5rc1, 2.1.0
    • Frontend (F)
    • RedHat OS
      MySQL Percona 5.5.29.
      Related PHP conf: 1GB memory_limit, 1h max_execution_time
      Database installed in a 64GB RAM and SSD-only server.

      my.cnf has been tunned well.
    • Sprint 24, Sprint 25, Sprint 26, Sprint 27
    • 4

      Only Zabbix Super Admin used always !

      On 2.0.3:
      We have a host template with 50 items and 10 triggers linked to 20.000 hosts approx.
      When we create/modify/delete an item/trigger the process fails after a long while (>30mins) and huge memory/cpu usage.

      With templates linked to less hosts (~100 hosts) everything works fine.

      On 2.0.5rc1 rev ~32712 (included bunch of expected performance improvements):
      We tried 2.0.5rc1 and it doesn't solve the problem:
      we change an item in a template linked to 10.000 hosts and it takes approx 20 minutes which is too long for the user to wait.
      we change an item in a template linked to 20.000 hosts and after a while (and huge cpu load) the process fails leaving just some hosts with the new added item.

            sasha Alexander Vladishev
            zalex_ua Oleksii Zagorskyi
            Team B
            14 Vote for this issue
            18 Start watching this issue