We stopped writing to this table in production, so far without any explosions. We can slowly start dropping it from prod.
Progress:
- s1
- s2
- s3
- s4
- s5
- s6
- s7
- s8
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Add 2023/drop_revision_comment_temp_T338284.py | operations/software/schema-changes | master | +36 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | daniel | T161671 Compacting the revision table | |||
| Resolved | None | T227047 Complete actor table and comment table migration | |||
| Resolved | None | T215466 Remove revision_comment_temp and revision_actor_temp | |||
| Resolved | Ladsgroup | T338284 Drop revision_comment_temp in production |
Event Timeline
Comment Actions
I just did this:
root@db2109.codfw.wmnet[testwiki]> RENAME TABLE revision_comment_temp TO T338284_revision_comment_temp;
Wait until next week to see if that breaks replication or errors and such and then we can move forward with dropping it everywhere.
Comment Actions
It hasn't been modified since June 6 in enwiki:
root@dbstore1003:/srv/sqldata.s1/enwiki# ls -l | grep -i revision_comment -rw-rw---- 1 mysql mysql 1470 May 19 07:26 revision_comment_temp.frm -rw-rw---- 1 mysql mysql 38084280320 Jun 6 22:49 revision_comment_temp.ibd
Comment Actions
Change 929668 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[operations/software/schema-changes@master] Add 2023/drop_revision_comment_temp_T338284.py
Comment Actions
Change 929668 merged by jenkins-bot:
[operations/software/schema-changes@master] Add 2023/drop_revision_comment_temp_T338284.py
