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

very slow query in housekeeper

    XMLWordPrintable

    Details

      Description

      new housekeeper is much more flexible, but it does some selects against events table that are very slow :

      select min(clock) from events where source=1

      on a not-too-fast test system with 11 million events this query took 2 hours.

      mysql> explain extended select min(clock) from events where source=1;
      ------------------------------------------------------------------------------

      id select_type table type possible_keys key key_len ref rows filtered Extra

      ------------------------------------------------------------------------------

      1 SIMPLE events ref events_1 events_1 4 const 5593118 100.00  

      ------------------------------------------------------------------------------

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: