Page MenuHomePhabricator

Adjust the field type of cx_notification_log.cxn_date/cxn_newest 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_notification_log-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_notification_log.ibd | xargs ls -lh
-rw-rw---- 1 mysql mysql 192K Jul  4 01:45 ./sqldata/wikishared/cx_notification_log.ibd

root@db1123:/srv# find . -name cx_notification_log.ibd | xargs ls -lh
-rw-rw---- 1 mysql mysql 112K Jul  1  2021 ./sqldata/testwiki/cx_notification_log.ibd