very slow query in housekeeper

XMLWordPrintable

      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  

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

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

              Created:
              Updated:
              Resolved: