- ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/TimedMediaHandler/+/1222601/2/sql/mysql/patch-transcode-state-size.sql
- Where to run those changes: all wikis
- 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: Already in beta cluster.
- If the data should be made available on the labs replicas and/or dumps: Yes
Description
Description
Details
Details
Related Changes in Gerrit:
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| filtered_tables.txt: Add new columns | operations/puppet | production | +3 -0 |
Related Changes in GitLab:
| Title | Reference | Author | Source Branch | Dest Branch | |
|---|---|---|---|---|---|
| Add status columns to transcode table | repos/sre/schema-changes!57 | fceratto | T413688 | main |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Open | None | T350816 Special:Transcode_statistics is very slow to load on Commons, cuts off lots of info | |||
| Open | None | T112931 Improve readability, reliability of Special:TimedMediaHandler reports | |||
| Open | Feature | None | T43867 Show active transcodes counts on Special:TimedMediaHandler | ||
| Open | None | T414419 Transcode table should refer to file id | |||
| Open | bvibber | T362123 Retool transcode table with a status column | |||
| Resolved | FCeratto-WMF | T413688 Add status columns to transcode table in wmf production |
Event Timeline
Comment Actions
This table is basically empty on all wikis except commons. In commons it's 1.7GB which is a bit big but not much.
Comment Actions
fceratto opened https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/57
Add status columns to transcode table
Comment Actions
fceratto merged https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/57
Add status columns to transcode table
Comment Actions
Change #1224533 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/puppet@production] filtered_tables.txt: Add new columns
Comment Actions
Change #1224533 merged by Marostegui:
[operations/puppet@production] filtered_tables.txt: Add new columns