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

10x performance increase on graphs permission check

    XMLWordPrintable

Details

    • Patch request
    • Status: Closed
    • Trivial
    • Resolution: Duplicate
    • 3.4.14
    • None
    • API (A)
    • None

    Description

      In our environment SQL query execution time for graphs permission check is 40 - 50 seconds.

      After combine 'check permissions by Y min item' and 'check permissions by Y max item' with 'check permissions by graph items', the query execution time is 4 - 5 seconds.

      Trivial patch [^zabbix-graph-permissions.diff]

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              eshkrig Eugeny Shkrigunov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: