Page MenuHomePhabricator

Adjust the field type of cx_lists.cxl_start_time/cxl_end_time to fixed binary on wmf wikis
Closed, ResolvedPublic

Description

Apply parts of T310448 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/ContentTranslation/+/804775/3/sql/patch-cx_lists-timestamps.sql
  2. Where to run those changes: All wikipedias (tables on x1.wikishared) + testwiki
  3. When to run those changes: any time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Event Timeline

Umherirrender updated the task description. (Show Details)
Marostegui claimed this task.
Marostegui added a subscriber: Marostegui.

Done on x1 and s3 master with replication enabled.
It was tiny enough:

root@db1137:/srv# find . -name cx_lists.ibd | xargs ls -lh
-rw-r----- 1 mysql mysql 9.0M Jul  6 01:06 ./sqldata/wikishared/cx_lists.ibd
root@db1123:/srv# find . -name cx_lists.ibd | xargs ls -lh
-rw-rw---- 1 mysql mysql 112K Jul  6 05:46 ./sqldata/testwiki/cx_lists.ibd