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

Makes changes to templates links to large numbers of hosts is very slow

    XMLWordPrintable

    Details

      Description

      Possibly this is related to ZBX-7700.

      Making changes to graphs/items/triggers on a template which is linked to large numbers of hosts can take a long time. Here are a couple of examples:

      1. Changing a graph item line to be a different color and changing the graph height to a different number took 40+ seconds to save. The template is inherited by around 4200 hosts
      2. Adding a new trigger to a template which is linked to 4200+ hosts took around 2.5 minutes to do.

      Just as in ZBX-7700, there are no DB problems. It's just ridiculously slow to do these processes. I don't have the callgraphs for these processes, but I'm willing to bet they'd see the same issues as ZBX-7700.

      To make this worse, these processes cause various tables in the database to be locked while they run. For example, the hosts/items tables can get locked. Having locks prevents data from getting into the tables and creates even more slowness on the UI. Right now, I have to seriously consider doing manual database queries to make changes at times just so I don't hose the Zabbix system by doing the changes through the UI.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              heaje Corey Shaw
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: