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

Very low performance changing template linked with many hosts

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 2.0.5rc1, 2.1.0
    • 3.4.8rc1, 4.0.0alpha4, 4.0 (plan)
    • 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.
    • Team B
    • Sprint 24, Sprint 25, Sprint 26, Sprint 27
    • 4

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              sasha Alexander Vladishev
              zalex_ua Oleksii Zagorskyi
              Votes:
              14 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: