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

Getting last event in CTrigger.php is very slow

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 2.0.8rc1
    • None
    • API (A)

    Description

      Getting last event in CTrigger.php is very slow on installations with old PROBLEM triggers, because the query:

      			$lastEvents = DBfetchArrayAssoc(DBselect(
				'SELECT '.$select.' FROM events e JOIN ('.
					'SELECT  max(eventid) as lasteventid FROM events e'.
					' WHERE '.dbConditionInt('e.objectid', $triggerids).
						' AND '.DBin_node('e.objectid').
						' AND e.object='.EVENT_SOURCE_TRIGGERS.
						' AND e.value_changed='.TRIGGER_VALUE_CHANGED_YES.
					' GROUP BY e.objectid'.
				') ee ON e.eventid=ee.lasteventid'

      parse a lot of data from events table. For example it is slow for triggers which have events with age more 1-2 months.

      Attachments

        Issue Links

          duplicates

          Incident report - Incident report ZBX-7983 Widget "System Status" is slow on installations with huge amount of PROBLEM triggers and Host Groups

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              dotneft Alexey Pustovalov
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: