Add fr_user index on flaggedrevs in production
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Sep 29 2022, 5:39 PM

Description

ALTERs to run: TBD
Where to run those changes: flaggedrevs.dblist
When to run those changes: At any time
If the schema change is backwards compatible: Yes.
If the schema change has been tested already on some of the test/beta wikis: This has been around for ten years on new wikis.
if the data should be made available on the labs replicas and/or dumps: The table only contains public data.

Status	Assigned	Task
Open	None	T313251 Collect and fix schema drifts of wmf-deployed extension tables in production
Resolved	Ladsgroup	T313253 Fix Flaggedrevs database schema drifts in production
Resolved	Ladsgroup	T318959 Add fr_user index on flaggedrevs in production

Ladsgroup triaged this task as Medium priority.Sep 29 2022, 5:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-10-11T17:26:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T318959)', diff saved to https://phabricator.wikimedia.org/P35409 and previous config saved to /var/cache/conftool/dbconfig/20221011-172608-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-10-11T17:28:22Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T318959)', diff saved to https://phabricator.wikimedia.org/P35410 and previous config saved to /var/cache/conftool/dbconfig/20221011-172822-ladsgroup.json

Ladsgroup closed this task as Resolved.Oct 11 2022, 5:28 PM

Ladsgroup moved this task from Ready to Done on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2022-10-11T18:13:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T318959)', diff saved to https://phabricator.wikimedia.org/P35414 and previous config saved to /var/cache/conftool/dbconfig/20221011-181348-ladsgroup.json