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

          causes

          Problem report - Problem report ZBX-14896 after ZBX-6118, still low performance changing template linked with many hosts

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Problem report - Problem report ZBX-14865 importing template error - Field "parent_itemid" cannot be set to NULL

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          duplicates

          Problem report - Problem report ZBX-2494 deadlock between server and frontend

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Incident report - Incident report ZBX-9620 Zabbix database server CPU 100%,when i modify low level dicovery rule or update the template

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-7701 Makes changes to templates links to large numbers of hosts is very slow

          • Major - Major loss of function.
          • Closed

          Problem report - Problem report ZBX-13348 Low performance creating Graph in template linked with many hosts

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Confirmed

          Problem report - Problem report ZBX-13349 Low performance creating Web Scenario in template linked with many hosts

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Confirmed

          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: