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

Widget "System Status" is slow on installations with huge amount of PROBLEM triggers and Host Groups

    XMLWordPrintable

Details

    Description

      ******************** Script profiler ********************
Total time: 39.737475
Total SQL time: 10.014377
SQL count: 5764 (selects: 5749 | executes: 15)
Peak memory usage: 461.25M
Memory limit: 1024M

      Amount of Host Groups: 2110
      Amount of PROBLEM triggers: 5709

      The issue is in selectLastEvent option. There is very slow place.

      Attachments

        Issue Links

          is duplicated by

          Incident report - Incident report ZBX-6869 Getting last event in CTrigger.php is very slow

          • Major - Major loss of function.
          • Closed

          Activity

            People

              iivs Ivo Kurzemnieks
              dotneft Alexey Pustovalov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: