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: