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

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


      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.

            Unassigned Unassigned
            heaje Corey Shaw
            2 Vote for this issue
            3 Start watching this issue