- ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/793910/3/backend/schema/mysql/patch-drop-fpc_select.sql
- Where to run those changes: flaggedrevs.dblist
- When to run those changes: When DBA has time.
- If the schema change is backwards compatible: Yes.
- If the schema change has been tested already on some of the test/beta wikis: beta cluster runs with the new schema
- if the data should be made available on the labs replicas and/or dumps: No change to current rules required.
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| mariadb: Remove fpc_select from filtered_tables.txt | operations/puppet | production | +0 -1 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T31744 FlaggedRev installation (deployment) requests (tracking) | |||
| Stalled | None | T143886 Activating Flagged revisions on ar.wikinews | |||
| Stalled | None | T204354 Flagged Revisions for Vietnamese Wikipedia | |||
| Stalled | None | T205145 Deploy FlaggedRevs on bn.wikibooks | |||
| Stalled | None | T221933 Enable Flagged Revisions (for trial run purpose) at the Chinese Wikipedia | |||
| Open | None | T185664 Code stewardship review: FlaggedRevs | |||
| Open | Ladsgroup | T277883 Drop all low-use and unused features of FlaggedRevs to make it more maintainable | |||
| Resolved | Zabe | T262978 flaggedpage_config.fpc_select is unused | |||
| Resolved | Ladsgroup | T308933 Drop flaggedpage_config.fpc_select column on wmf wikis |
Event Timeline
Comment Actions
Change 796534 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[operations/puppet@production] mariadb: Remove fpc_select from filtered_tables.txt
Comment Actions
Change 796534 abandoned by Ladsgroup:
[operations/puppet@production] mariadb: Remove fpc_select from filtered_tables.txt
Reason:
I482f67c8c64e21a
Comment Actions
@Ladsgroup has the schema change already been applied to production? Or is it just the views that were updated
Comment Actions
Yeah, it's a small table with not that much reads nor writes so I could run the alter on master with replication and in the cloud, I ran maintain-views live.