-
Incident report
-
Resolution: Fixed
-
Critical
-
2.1.7
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 |
------------------------------------------------------------------------------