Page MenuHomePhabricator
Create Task
Maniphest T399728

Add '*_actor_ip_hex_time' indexes to 'cu_changes', 'cu_log_event', and 'cu_private_event' on WMF wikis
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run:
    1. https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/cea6298ea4cd3275a703c24e5f5ee3f392d24b7f/schema/mysql/patch-cu_changes-add-index-cuc_actor_ip_hex_time.sql
    2. https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/cea6298ea4cd3275a703c24e5f5ee3f392d24b7f/schema/mysql/patch-cu_log_event-add-index-cule_actor_ip_hex_time.sql
    3. https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/cea6298ea4cd3275a703c24e5f5ee3f392d24b7f/schema/mysql/patch-cu_private_event-add-index-cupe_actor_ip_hex_time.sql
  2. Where to run those changes: all.dblist
  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: CheckUser is not in the beta cluster, so no
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed (should remain private)

Status:

  • s1
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s2
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s3
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s4
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s5
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s6
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s7
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master
  • s8
    • codfw replicas
    • codfw DC master
    • eqiad replicas
    • eqiad DC master

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
Add simple helper to coordinate schema changesrepos/sre/schema-changes!42fcerattohelpermain
Add '*_actor_ip_hex_time' indexesrepos/sre/schema-changes!41fcerattoT399728main
Customize query in GitLab

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Aug 6 2025, 10:47 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T10:47:43Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T399728)', diff saved to https://phabricator.wikimedia.org/P80898 and previous config saved to /var/cache/conftool/dbconfig/20250806-104743-fceratto.json

Stashbot added a comment.Aug 6 2025, 10:48 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T10:48:06Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1206 (T399728)', diff saved to https://phabricator.wikimedia.org/P80899 and previous config saved to /var/cache/conftool/dbconfig/20250806-104805-fceratto.json

Stashbot added a comment.Aug 6 2025, 10:50 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T10:50:48Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T399728)', diff saved to https://phabricator.wikimedia.org/P80900 and previous config saved to /var/cache/conftool/dbconfig/20250806-105047-fceratto.json

Stashbot added a comment.Aug 6 2025, 11:36 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T11:36:10Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T399728)', diff saved to https://phabricator.wikimedia.org/P80903 and previous config saved to /var/cache/conftool/dbconfig/20250806-113609-fceratto.json

Stashbot added a comment.Aug 6 2025, 11:36 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T11:36:34Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1218 (T399728)', diff saved to https://phabricator.wikimedia.org/P80904 and previous config saved to /var/cache/conftool/dbconfig/20250806-113633-fceratto.json

Stashbot added a comment.Aug 6 2025, 11:52 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T11:52:16Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T399728)', diff saved to https://phabricator.wikimedia.org/P80905 and previous config saved to /var/cache/conftool/dbconfig/20250806-115216-fceratto.json

Stashbot added a comment.Aug 6 2025, 12:37 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T12:37:39Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T399728)', diff saved to https://phabricator.wikimedia.org/P80908 and previous config saved to /var/cache/conftool/dbconfig/20250806-123738-fceratto.json

Stashbot added a comment.Aug 6 2025, 12:37 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T12:37:52Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1219 (T399728)', diff saved to https://phabricator.wikimedia.org/P80909 and previous config saved to /var/cache/conftool/dbconfig/20250806-123751-fceratto.json

Stashbot added a comment.Aug 6 2025, 12:41 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T12:41:41Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T399728)', diff saved to https://phabricator.wikimedia.org/P80910 and previous config saved to /var/cache/conftool/dbconfig/20250806-124140-fceratto.json

Stashbot added a comment.Aug 6 2025, 1:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T13:27:03Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T399728)', diff saved to https://phabricator.wikimedia.org/P80913 and previous config saved to /var/cache/conftool/dbconfig/20250806-132703-fceratto.json

Stashbot added a comment.Aug 6 2025, 1:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T13:27:26Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1232 (T399728)', diff saved to https://phabricator.wikimedia.org/P80914 and previous config saved to /var/cache/conftool/dbconfig/20250806-132725-fceratto.json

Stashbot added a comment.Aug 6 2025, 1:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T13:31:16Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T399728)', diff saved to https://phabricator.wikimedia.org/P80915 and previous config saved to /var/cache/conftool/dbconfig/20250806-133115-fceratto.json

Stashbot added a comment.Aug 6 2025, 2:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T14:16:38Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T399728)', diff saved to https://phabricator.wikimedia.org/P80918 and previous config saved to /var/cache/conftool/dbconfig/20250806-141638-fceratto.json

Stashbot added a comment.Aug 6 2025, 2:17 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T14:17:01Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1234 (T399728)', diff saved to https://phabricator.wikimedia.org/P80919 and previous config saved to /var/cache/conftool/dbconfig/20250806-141701-fceratto.json

Stashbot added a comment.Aug 6 2025, 2:20 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T14:20:46Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T399728)', diff saved to https://phabricator.wikimedia.org/P80920 and previous config saved to /var/cache/conftool/dbconfig/20250806-142046-fceratto.json

Stashbot added a comment.Aug 6 2025, 3:06 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T15:06:09Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T399728)', diff saved to https://phabricator.wikimedia.org/P80923 and previous config saved to /var/cache/conftool/dbconfig/20250806-150609-fceratto.json

Stashbot added a comment.Aug 6 2025, 3:06 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T15:06:32Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1235 (T399728)', diff saved to https://phabricator.wikimedia.org/P80924 and previous config saved to /var/cache/conftool/dbconfig/20250806-150631-fceratto.json

Stashbot added a comment.Aug 6 2025, 3:10 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T15:10:18Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T399728)', diff saved to https://phabricator.wikimedia.org/P80925 and previous config saved to /var/cache/conftool/dbconfig/20250806-151017-fceratto.json

Stashbot added a comment.Aug 6 2025, 3:55 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T15:55:40Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T399728)', diff saved to https://phabricator.wikimedia.org/P80928 and previous config saved to /var/cache/conftool/dbconfig/20250806-155540-fceratto.json

Stashbot added a comment.Aug 6 2025, 3:59 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T15:59:40Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1251 (T399728)', diff saved to https://phabricator.wikimedia.org/P80929 and previous config saved to /var/cache/conftool/dbconfig/20250806-155939-fceratto.json

Stashbot added a comment.Aug 6 2025, 4:03 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T16:03:24Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1251 (T399728)', diff saved to https://phabricator.wikimedia.org/P80930 and previous config saved to /var/cache/conftool/dbconfig/20250806-160323-fceratto.json

Stashbot added a comment.Aug 6 2025, 4:48 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-06T16:48:47Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1251 (T399728)', diff saved to https://phabricator.wikimedia.org/P80935 and previous config saved to /var/cache/conftool/dbconfig/20250806-164846-fceratto.json

Stashbot added a comment.Aug 7 2025, 7:43 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T07:43:07Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1157 (T399728)', diff saved to https://phabricator.wikimedia.org/P80940 and previous config saved to /var/cache/conftool/dbconfig/20250807-074306-fceratto.json

Stashbot added a comment.Aug 7 2025, 7:48 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T07:48:04Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T399728)', diff saved to https://phabricator.wikimedia.org/P80941 and previous config saved to /var/cache/conftool/dbconfig/20250807-074803-fceratto.json

Stashbot added a comment.Aug 7 2025, 8:33 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T08:33:26Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T399728)', diff saved to https://phabricator.wikimedia.org/P80944 and previous config saved to /var/cache/conftool/dbconfig/20250807-083325-fceratto.json

Stashbot added a comment.Aug 7 2025, 8:33 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T08:33:49Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1166 (T399728)', diff saved to https://phabricator.wikimedia.org/P80945 and previous config saved to /var/cache/conftool/dbconfig/20250807-083348-fceratto.json

Stashbot added a comment.Aug 7 2025, 8:38 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T08:38:49Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T399728)', diff saved to https://phabricator.wikimedia.org/P80946 and previous config saved to /var/cache/conftool/dbconfig/20250807-083848-fceratto.json

Stashbot added a comment.Aug 7 2025, 9:24 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T09:24:11Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T399728)', diff saved to https://phabricator.wikimedia.org/P80949 and previous config saved to /var/cache/conftool/dbconfig/20250807-092410-fceratto.json

Stashbot added a comment.Aug 7 2025, 9:24 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T09:24:34Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1175 (T399728)', diff saved to https://phabricator.wikimedia.org/P80950 and previous config saved to /var/cache/conftool/dbconfig/20250807-092433-fceratto.json

Stashbot added a comment.Aug 7 2025, 9:29 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T09:29:30Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T399728)', diff saved to https://phabricator.wikimedia.org/P80951 and previous config saved to /var/cache/conftool/dbconfig/20250807-092930-fceratto.json

Stashbot added a comment.Aug 7 2025, 10:14 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T10:14:53Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T399728)', diff saved to https://phabricator.wikimedia.org/P80954 and previous config saved to /var/cache/conftool/dbconfig/20250807-101452-fceratto.json

Stashbot added a comment.Aug 7 2025, 10:15 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T10:15:15Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1189 (T399728)', diff saved to https://phabricator.wikimedia.org/P80955 and previous config saved to /var/cache/conftool/dbconfig/20250807-101515-fceratto.json

Stashbot added a comment.Aug 7 2025, 10:20 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T10:20:05Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T399728)', diff saved to https://phabricator.wikimedia.org/P80956 and previous config saved to /var/cache/conftool/dbconfig/20250807-102004-fceratto.json

Stashbot added a comment.Aug 7 2025, 11:05 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T11:05:27Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T399728)', diff saved to https://phabricator.wikimedia.org/P80959 and previous config saved to /var/cache/conftool/dbconfig/20250807-110527-fceratto.json

Stashbot added a comment.Aug 7 2025, 11:05 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T11:05:50Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1198 (T399728)', diff saved to https://phabricator.wikimedia.org/P80960 and previous config saved to /var/cache/conftool/dbconfig/20250807-110549-fceratto.json

Stashbot added a comment.Aug 7 2025, 11:10 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T11:10:44Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1198 (T399728)', diff saved to https://phabricator.wikimedia.org/P80961 and previous config saved to /var/cache/conftool/dbconfig/20250807-111043-fceratto.json

Stashbot added a comment.Aug 7 2025, 11:56 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T11:56:07Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1198 (T399728)', diff saved to https://phabricator.wikimedia.org/P80965 and previous config saved to /var/cache/conftool/dbconfig/20250807-115606-fceratto.json

Stashbot added a comment.Aug 7 2025, 11:56 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T11:56:47Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1212 (T399728)', diff saved to https://phabricator.wikimedia.org/P80966 and previous config saved to /var/cache/conftool/dbconfig/20250807-115646-fceratto.json

Stashbot added a comment.Aug 7 2025, 12:02 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T12:02:06Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1212 (T399728)', diff saved to https://phabricator.wikimedia.org/P80967 and previous config saved to /var/cache/conftool/dbconfig/20250807-120205-fceratto.json

Stashbot added a comment.Aug 7 2025, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-07T12:47:29Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1212 (T399728)', diff saved to https://phabricator.wikimedia.org/P80972 and previous config saved to /var/cache/conftool/dbconfig/20250807-124728-fceratto.json

FCeratto-WMF updated the task description. (Show Details)Aug 7 2025, 5:54 PM
FCeratto-WMF updated the task description. (Show Details)Aug 11 2025, 9:04 AM
FCeratto-WMF updated the task description. (Show Details)Aug 11 2025, 9:36 AM
FCeratto-WMF updated the task description. (Show Details)Aug 11 2025, 10:46 AM
FCeratto-WMF updated the task description. (Show Details)Aug 11 2025, 12:52 PM
FCeratto-WMF mentioned this in rSCHCH35642c35fbff: Add simple helper to coordinate schema changes.Aug 20 2025, 1:06 PM
FCeratto-WMF mentioned this in rSCHCH7fc755e9b469: Add simple helper to coordinate schema changes.Aug 25 2025, 1:01 PM
Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:27 AM
Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:36 AM
Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:44 AM
Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:47 AM
Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:50 AM
Ladsgroup subscribed.

Done in all masters since this could have been done live on them with exception of s1 and s8. They require switchovers, I'll do s1 soon.

Ladsgroup updated the task description. (Show Details)Sep 2 2025, 2:58 PM
Ladsgroup closed this task as Resolved.Sep 9 2025, 12:30 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.
FCeratto-WMF mentioned this in rSCHCHdb8f9ca3f120: Add simple helper to coordinate schema changes.Mon, Dec 1, 12:56 PM
CodeReviewBot added a comment.Mon, Dec 1, 1:10 PM

fceratto merged https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/42

Add simple helper to coordinate schema changes

Restricted Application added a project: Data-Engineering. · View Herald TranscriptMon, Dec 1, 1:10 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits