diff options
| author | Amir Sarabadani <ladsgroup@gmail.com> | 2022-05-16 15:55:04 +0200 |
|---|---|---|
| committer | Ladsgroup <Ladsgroup@gmail.com> | 2022-05-17 08:32:23 +0000 |
| commit | eefe966fb9550fb3d8c19a9a7b945d31e65ffb87 (patch) | |
| tree | 6da581e0f32a8827158ccec738ba6aa0c4955c0f | |
| parent | 3f1fc69e96cdd1474acda8f86561bfcd3547f9e6 (diff) | |
ContribsPager: Update index hint to use revision table in READ NEWwmf/1.39.0-wmf.10
We finished migration and now it should hint on the correct index on
revision table.
Bug: T307295
Change-Id: Ie2fa9f7be158b88cb8ea063735224de716852e52
| -rw-r--r-- | includes/specials/pagers/ContribsPager.php | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/includes/specials/pagers/ContribsPager.php b/includes/specials/pagers/ContribsPager.php index f24737efcf5f..dd421ebc87c1 100644 --- a/includes/specials/pagers/ContribsPager.php +++ b/includes/specials/pagers/ContribsPager.php @@ -389,10 +389,13 @@ class ContribsPager extends RangeChronologicalPager { // tables and joins are already handled by RevisionStore::getQueryInfo() $conds = $this->actorMigration->getWhere( $dbr, 'rev_user', $this->targetUser ); $queryInfo['conds'][] = $conds['conds']; - // Force the appropriate index to avoid bad query plans (T189026) + // Force the appropriate index to avoid bad query plans (T189026 and T307295) if ( isset( $conds['orconds']['actor'] ) ) { $queryInfo['options']['USE INDEX']['temp_rev_user'] = 'actor_timestamp'; } + if ( isset( $conds['orconds']['newactor'] ) ) { + $queryInfo['options']['USE INDEX']['revision'] = 'rev_actor_timestamp'; + } } if ( $this->deletedOnly ) { |