| Ladsgroup | |
| May 12 2022, 8:03 AM |
| F35133812: image.png | |
| May 12 2022, 8:03 AM |
SELECT /* ApiQueryInfo::getProtectionInfo */ pr_type,pr_level,pr_expiry,page_title,page_namespace,lt_namespace,lt_title FROM `page_restrictions`,`page`,`templatelinks` JOIN `linktarget` ON ((tl_target_id=lt_id)) WHERE ((lt_namespace = 10 AND lt_title IN ('De-ch','Falschschreibung','Hinweisbaustein','“','„') )) AND (pr_page = page_id) AND (pr_page = tl_from) AND pr_cascade = 1| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T300222 Implement normalizing MediaWiki link tables | |||
| Resolved | Ladsgroup | T299417 Normalize templatelinks table | |||
| Resolved | Ladsgroup | T308207 ApiQueryInfo::getProtectionInfo is slow on normalized templatelinks |
Change 791312 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@master] api: Force PRIMARY index on templatelinks for checking cascade protection
Some random queries you can try to check.
SELECT lt_namespace,lt_title FROM`templatelinks` JOIN `linktarget` ON ((tl_target_id=lt_id)) WHERE ((lt_namespace = 10 AND lt_title IN ('De-ch','Falschschreibung','Hinweisbaustein','“','„') ));
SELECT pr_type,pr_level,pr_expiry,page_title,page_namespace,tl_namespace,tl_title FROM `page_restrictions`,`page`,`templatelinks` WHERE ((tl_namespace = 10 AND tl_title IN ('De-ch','Falschschreibung','Hinweisbaustein','“','„')) AND (pr_page = page_id) AND (pr_page = tl_from) AND pr_cascade = 1 ;
SELECT lt_id FROM `linktarget` WHERE ((lt_namespace = 10 AND lt_title IN ('De-ch','Falschschreibung','Hinweisbaustein','“','„') ));
SELECT /* ApiQueryInfo::getProtectionInfo */ pr_type,pr_level,pr_expiry,page_title,page_namespace FROM `page_restrictions`,`page`,`templatelinks` WHERE ((tl_target_id IN (44, 9792, 24, 45, 43) )) AND (pr_page = page_id) AND (pr_page = tl_from) AND pr_cascade = 1One way to address this is to load the lt_target_id and avoid joining to linktarget altogether but then you have keep the id in place so you wouldn't need to get lt_title and lt_namespace.
Change 791316 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@master] RestrictionStore: Add support for templatelinks migration
Change 791252 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.39.0-wmf.10] ApiQueryInfo: Force PRIMARY index on templatelinks
Change 791253 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.39.0-wmf.11] ApiQueryInfo: Force PRIMARY index on templatelinks
Change 791312 merged by jenkins-bot:
[mediawiki/core@master] ApiQueryInfo: Force PRIMARY index on templatelinks
Change 791253 merged by jenkins-bot:
[mediawiki/core@wmf/1.39.0-wmf.11] ApiQueryInfo: Force PRIMARY index on templatelinks
Change 791252 merged by Ladsgroup:
[mediawiki/core@wmf/1.39.0-wmf.10] ApiQueryInfo: Force PRIMARY index on templatelinks
Mentioned in SAL (#wikimedia-operations) [2022-05-12T12:30:52Z] <ladsgroup@deploy1002> Synchronized php-1.39.0-wmf.10/includes/api/ApiQueryInfo.php: Backport: [[gerrit:791252|ApiQueryInfo: Force PRIMARY index on templatelinks (T308207)]] (duration: 00m 50s)
Change 791316 merged by jenkins-bot:
[mediawiki/core@master] RestrictionStore: Add support for templatelinks migration
Change 791745 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.39.0-wmf.11] RestrictionStore: Add support for templatelinks migration
Change 791745 merged by jenkins-bot:
[mediawiki/core@wmf/1.39.0-wmf.11] RestrictionStore: Add support for templatelinks migration
Change 792126 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.39.0-wmf.10] RestrictionStore: Add support for templatelinks migration
Change 792126 merged by jenkins-bot:
[mediawiki/core@wmf/1.39.0-wmf.10] RestrictionStore: Add support for templatelinks migration
Mentioned in SAL (#wikimedia-operations) [2022-05-16T11:09:15Z] <ladsgroup@deploy1002> Synchronized php-1.39.0-wmf.10/includes: Backport: [[gerrit:792126|RestrictionStore: Add support for templatelinks migration (T308207)]] (duration: 00m 54s)