Page MenuHomePhabricator

Add index on file.file_type in wmf production
Closed, ResolvedPublic

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1355098/3/sql/mysql/patch-file-file_type_name.sql
  2. Where to run those changes: all wikis
  3. When to run those changes: When DBA has 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: Already in beta cluster.
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed

Progress

  • s1
    • codfw
    • eqiad
  • s2
    • codfw
    • eqiad
  • s3
    • codfw
    • eqiad
  • s4
    • codfw
    • eqiad
  • s5
    • codfw
    • eqiad
  • s6
    • codfw
    • eqiad
  • s7
    • codfw
    • eqiad
  • s8
    • codfw
    • eqiad

The server-by-server progress can be monitored on https://zarcillo.wikimedia.org/ui/schema_change (requires login)

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
add_file_type_name_T441197.py: New schema changerepos/sre/schema-changes!70marosteguiT441197main
Customize query in GitLab

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
ResolvedZabe
ResolvedMarostegui

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Mentioned in SAL (#wikimedia-operations) [2026-10-16T12:08:22Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2206 (T441197)', diff saved to https://phabricator.wikimedia.org/P96731 and previous config saved to /var/cache/conftool/dbconfig/20261016-120821-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T12:08:39Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db2210 (T441197)', diff saved to https://phabricator.wikimedia.org/P96732 and previous config saved to /var/cache/conftool/dbconfig/20261016-120839-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T12:16:28Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2210 (T441197)', diff saved to https://phabricator.wikimedia.org/P96733 and previous config saved to /var/cache/conftool/dbconfig/20261016-121628-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T13:01:34Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2210 (T441197)', diff saved to https://phabricator.wikimedia.org/P96736 and previous config saved to /var/cache/conftool/dbconfig/20261016-130133-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T13:01:52Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db2219 (T441197)', diff saved to https://phabricator.wikimedia.org/P96737 and previous config saved to /var/cache/conftool/dbconfig/20261016-130151-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T13:09:59Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2219 (T441197)', diff saved to https://phabricator.wikimedia.org/P96738 and previous config saved to /var/cache/conftool/dbconfig/20261016-130958-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T13:55:05Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2219 (T441197)', diff saved to https://phabricator.wikimedia.org/P96746 and previous config saved to /var/cache/conftool/dbconfig/20261016-135504-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T13:55:23Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db2236 (T441197)', diff saved to https://phabricator.wikimedia.org/P96747 and previous config saved to /var/cache/conftool/dbconfig/20261016-135522-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T14:03:21Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T441197)', diff saved to https://phabricator.wikimedia.org/P96748 and previous config saved to /var/cache/conftool/dbconfig/20261016-140320-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T14:48:27Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T441197)', diff saved to https://phabricator.wikimedia.org/P96753 and previous config saved to /var/cache/conftool/dbconfig/20261016-144826-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T14:48:45Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db2237 (T441197)', diff saved to https://phabricator.wikimedia.org/P96754 and previous config saved to /var/cache/conftool/dbconfig/20261016-144844-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T14:56:39Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T441197)', diff saved to https://phabricator.wikimedia.org/P96755 and previous config saved to /var/cache/conftool/dbconfig/20261016-145638-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T15:41:45Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T441197)', diff saved to https://phabricator.wikimedia.org/P96759 and previous config saved to /var/cache/conftool/dbconfig/20261016-154144-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T15:50:41Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db2240 (T441197)', diff saved to https://phabricator.wikimedia.org/P96760 and previous config saved to /var/cache/conftool/dbconfig/20261016-155040-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T15:58:34Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T441197)', diff saved to https://phabricator.wikimedia.org/P96761 and previous config saved to /var/cache/conftool/dbconfig/20261016-155833-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-16T16:43:40Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T441197)', diff saved to https://phabricator.wikimedia.org/P96764 and previous config saved to /var/cache/conftool/dbconfig/20261016-164339-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T06:26:28Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1199 (T441197)', diff saved to https://phabricator.wikimedia.org/P96770 and previous config saved to /var/cache/conftool/dbconfig/20261019-062627-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T06:35:54Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1199 (T441197)', diff saved to https://phabricator.wikimedia.org/P96771 and previous config saved to /var/cache/conftool/dbconfig/20261019-063553-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T07:21:00Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1199 (T441197)', diff saved to https://phabricator.wikimedia.org/P96774 and previous config saved to /var/cache/conftool/dbconfig/20261019-072059-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T07:21:28Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1221 (T441197)', diff saved to https://phabricator.wikimedia.org/P96775 and previous config saved to /var/cache/conftool/dbconfig/20261019-072128-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T08:21:42Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T441197)', diff saved to https://phabricator.wikimedia.org/P96777 and previous config saved to /var/cache/conftool/dbconfig/20261019-082141-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T09:06:48Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T441197)', diff saved to https://phabricator.wikimedia.org/P96780 and previous config saved to /var/cache/conftool/dbconfig/20261019-090647-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T09:07:05Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1228 (T441197)', diff saved to https://phabricator.wikimedia.org/P96781 and previous config saved to /var/cache/conftool/dbconfig/20261019-090704-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T09:14:58Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1228 (T441197)', diff saved to https://phabricator.wikimedia.org/P96782 and previous config saved to /var/cache/conftool/dbconfig/20261019-091458-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T10:00:05Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1228 (T441197)', diff saved to https://phabricator.wikimedia.org/P96786 and previous config saved to /var/cache/conftool/dbconfig/20261019-100004-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T10:00:22Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1238 (T441197)', diff saved to https://phabricator.wikimedia.org/P96787 and previous config saved to /var/cache/conftool/dbconfig/20261019-100021-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T10:08:17Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1238 (T441197)', diff saved to https://phabricator.wikimedia.org/P96788 and previous config saved to /var/cache/conftool/dbconfig/20261019-100816-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T10:53:22Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1238 (T441197)', diff saved to https://phabricator.wikimedia.org/P96791 and previous config saved to /var/cache/conftool/dbconfig/20261019-105322-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T10:53:42Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1242 (T441197)', diff saved to https://phabricator.wikimedia.org/P96792 and previous config saved to /var/cache/conftool/dbconfig/20261019-105339-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T11:02:05Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T441197)', diff saved to https://phabricator.wikimedia.org/P96793 and previous config saved to /var/cache/conftool/dbconfig/20261019-110204-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T11:47:12Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T441197)', diff saved to https://phabricator.wikimedia.org/P96797 and previous config saved to /var/cache/conftool/dbconfig/20261019-114711-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T11:47:30Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1244 (T441197)', diff saved to https://phabricator.wikimedia.org/P96798 and previous config saved to /var/cache/conftool/dbconfig/20261019-114728-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T11:55:17Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T441197)', diff saved to https://phabricator.wikimedia.org/P96799 and previous config saved to /var/cache/conftool/dbconfig/20261019-115516-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T12:40:23Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T441197)', diff saved to https://phabricator.wikimedia.org/P96802 and previous config saved to /var/cache/conftool/dbconfig/20261019-124022-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T12:40:40Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1247 (T441197)', diff saved to https://phabricator.wikimedia.org/P96803 and previous config saved to /var/cache/conftool/dbconfig/20261019-124039-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T12:48:43Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T441197)', diff saved to https://phabricator.wikimedia.org/P96804 and previous config saved to /var/cache/conftool/dbconfig/20261019-124842-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T13:33:50Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T441197)', diff saved to https://phabricator.wikimedia.org/P96807 and previous config saved to /var/cache/conftool/dbconfig/20261019-133348-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T13:34:06Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1248 (T441197)', diff saved to https://phabricator.wikimedia.org/P96808 and previous config saved to /var/cache/conftool/dbconfig/20261019-133406-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T13:44:41Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T441197)', diff saved to https://phabricator.wikimedia.org/P96810 and previous config saved to /var/cache/conftool/dbconfig/20261019-134441-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T14:29:47Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T441197)', diff saved to https://phabricator.wikimedia.org/P96819 and previous config saved to /var/cache/conftool/dbconfig/20261019-142947-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T14:30:05Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1249 (T441197)', diff saved to https://phabricator.wikimedia.org/P96820 and previous config saved to /var/cache/conftool/dbconfig/20261019-143004-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T15:22:58Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T441197)', diff saved to https://phabricator.wikimedia.org/P96831 and previous config saved to /var/cache/conftool/dbconfig/20261019-152257-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T15:23:16Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1252 (T441197)', diff saved to https://phabricator.wikimedia.org/P96832 and previous config saved to /var/cache/conftool/dbconfig/20261019-152315-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T15:32:20Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T441197)', diff saved to https://phabricator.wikimedia.org/P96834 and previous config saved to /var/cache/conftool/dbconfig/20261019-153219-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T16:17:26Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T441197)', diff saved to https://phabricator.wikimedia.org/P96843 and previous config saved to /var/cache/conftool/dbconfig/20261019-161725-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T17:03:46Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Depooling db1221 (T441197)', diff saved to https://phabricator.wikimedia.org/P96850 and previous config saved to /var/cache/conftool/dbconfig/20261019-170345-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T17:11:37Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T441197)', diff saved to https://phabricator.wikimedia.org/P96852 and previous config saved to /var/cache/conftool/dbconfig/20261019-171136-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2026-10-19T17:56:43Z] <marostegui@cumin1004> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T441197)', diff saved to https://phabricator.wikimedia.org/P96857 and previous config saved to /var/cache/conftool/dbconfig/20261019-175642-marostegui.json

Marostegui updated the task description. (Show Details)

All done