Page MenuHomePhabricator

update_flaggedrevs does full table scan
Closed, ResolvedPublic

Description

Author: river

Description:
following query runs on dewiki:

UPDATE /* update_flaggedrevs 127.0.0.1 */ flaggedrevs SET fr_quality = '0',fr_img_name = NULL,fr_img_sha1 = NULL,fr_img_timestamp = NULL WHERE fr_rev_id = '8648547';

however, there is no index on fr_rev_id, only (fr_page_id,fr_rev_id). therefore no index is used for the query.


Version: unspecified
Severity: critical

Details

Reference
bz15094