Page MenuHomePhabricator
Create Task
Maniphest T400854

Add rc_source_name_timestamp index to recentchanges table in wmf production
Closed, ResolvedPublic
Actions

Description

  1. ALTER to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1174520/6/sql/mysql/patch-recentchanges-rc_source_name_timestamp.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: Change is running in beta cluster
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed

Progress:

  • s1: Done
  • s2: Done
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
Add add_rc_source_name_timestamp.pyrepos/sre/schema-changes!43ladsgrouprc_indexmain
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 14 2025, 1:11 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T01:11:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1238 (T400854)', diff saved to https://phabricator.wikimedia.org/P81309 and previous config saved to /var/cache/conftool/dbconfig/20250814-011152-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 1:12 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T01:12:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1241 (T400854)', diff saved to https://phabricator.wikimedia.org/P81310 and previous config saved to /var/cache/conftool/dbconfig/20250814-011215-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 1:16 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T01:16:43Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1241 (T400854)', diff saved to https://phabricator.wikimedia.org/P81311 and previous config saved to /var/cache/conftool/dbconfig/20250814-011642-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 2:02 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T02:02:05Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1241 (T400854)', diff saved to https://phabricator.wikimedia.org/P81314 and previous config saved to /var/cache/conftool/dbconfig/20250814-020205-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 2:02 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T02:02:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1242 (T400854)', diff saved to https://phabricator.wikimedia.org/P81315 and previous config saved to /var/cache/conftool/dbconfig/20250814-020228-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 2:07 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T02:07:38Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T400854)', diff saved to https://phabricator.wikimedia.org/P81316 and previous config saved to /var/cache/conftool/dbconfig/20250814-020737-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 2:53 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T02:53:01Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T400854)', diff saved to https://phabricator.wikimedia.org/P81319 and previous config saved to /var/cache/conftool/dbconfig/20250814-025300-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 2:53 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T02:53:24Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1243 (T400854)', diff saved to https://phabricator.wikimedia.org/P81320 and previous config saved to /var/cache/conftool/dbconfig/20250814-025323-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 2:58 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T02:58:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T400854)', diff saved to https://phabricator.wikimedia.org/P81321 and previous config saved to /var/cache/conftool/dbconfig/20250814-025808-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 3:43 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T03:43:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T400854)', diff saved to https://phabricator.wikimedia.org/P81324 and previous config saved to /var/cache/conftool/dbconfig/20250814-034332-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 3:47 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T03:47:35Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1247 (T400854)', diff saved to https://phabricator.wikimedia.org/P81325 and previous config saved to /var/cache/conftool/dbconfig/20250814-034734-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 3:51 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T03:51:56Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T400854)', diff saved to https://phabricator.wikimedia.org/P81326 and previous config saved to /var/cache/conftool/dbconfig/20250814-035155-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 4:37 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T04:37:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T400854)', diff saved to https://phabricator.wikimedia.org/P81329 and previous config saved to /var/cache/conftool/dbconfig/20250814-043719-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 4:37 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T04:37:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1248 (T400854)', diff saved to https://phabricator.wikimedia.org/P81330 and previous config saved to /var/cache/conftool/dbconfig/20250814-043732-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 4:42 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T04:42:46Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T400854)', diff saved to https://phabricator.wikimedia.org/P81331 and previous config saved to /var/cache/conftool/dbconfig/20250814-044246-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 5:28 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T05:28:10Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T400854)', diff saved to https://phabricator.wikimedia.org/P81334 and previous config saved to /var/cache/conftool/dbconfig/20250814-052809-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 5:28 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T05:28:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1249 (T400854)', diff saved to https://phabricator.wikimedia.org/P81335 and previous config saved to /var/cache/conftool/dbconfig/20250814-052831-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 5:32 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T05:32:53Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T400854)', diff saved to https://phabricator.wikimedia.org/P81336 and previous config saved to /var/cache/conftool/dbconfig/20250814-053252-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 6:18 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T06:18:16Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T400854)', diff saved to https://phabricator.wikimedia.org/P81339 and previous config saved to /var/cache/conftool/dbconfig/20250814-061816-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 6:18 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T06:18:39Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1252 (T400854)', diff saved to https://phabricator.wikimedia.org/P81340 and previous config saved to /var/cache/conftool/dbconfig/20250814-061838-ladsgroup.json

Stashbot added a comment.Aug 14 2025, 6:24 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-14T06:24:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T400854)', diff saved to https://phabricator.wikimedia.org/P81341 and previous config saved to /var/cache/conftool/dbconfig/20250814-062409-ladsgroup.json

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

Mentioned in SAL (#wikimedia-operations) [2025-08-14T07:09:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T400854)', diff saved to https://phabricator.wikimedia.org/P81344 and previous config saved to /var/cache/conftool/dbconfig/20250814-070932-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 10:12 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T22:12:55Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2147 (T400854)', diff saved to https://phabricator.wikimedia.org/P81378 and previous config saved to /var/cache/conftool/dbconfig/20250816-221254-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 10:17 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T22:17:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T400854)', diff saved to https://phabricator.wikimedia.org/P81379 and previous config saved to /var/cache/conftool/dbconfig/20250816-221708-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 11:02 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T23:02:31Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T400854)', diff saved to https://phabricator.wikimedia.org/P81382 and previous config saved to /var/cache/conftool/dbconfig/20250816-230231-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 11:02 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T23:02:54Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2155 (T400854)', diff saved to https://phabricator.wikimedia.org/P81383 and previous config saved to /var/cache/conftool/dbconfig/20250816-230254-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 11:07 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T23:07:07Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T400854)', diff saved to https://phabricator.wikimedia.org/P81384 and previous config saved to /var/cache/conftool/dbconfig/20250816-230707-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 11:52 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T23:52:30Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T400854)', diff saved to https://phabricator.wikimedia.org/P81387 and previous config saved to /var/cache/conftool/dbconfig/20250816-235229-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 11:52 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T23:52:53Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2172 (T400854)', diff saved to https://phabricator.wikimedia.org/P81388 and previous config saved to /var/cache/conftool/dbconfig/20250816-235253-ladsgroup.json

Stashbot added a comment.Aug 16 2025, 11:57 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-16T23:57:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T400854)', diff saved to https://phabricator.wikimedia.org/P81389 and previous config saved to /var/cache/conftool/dbconfig/20250816-235708-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 12:42 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T00:42:33Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T400854)', diff saved to https://phabricator.wikimedia.org/P81392 and previous config saved to /var/cache/conftool/dbconfig/20250817-004231-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 12:46 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T00:46:17Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2206 (T400854)', diff saved to https://phabricator.wikimedia.org/P81393 and previous config saved to /var/cache/conftool/dbconfig/20250817-004616-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 12:50 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T00:50:02Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2206 (T400854)', diff saved to https://phabricator.wikimedia.org/P81394 and previous config saved to /var/cache/conftool/dbconfig/20250817-005002-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 1:35 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T01:35:25Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2206 (T400854)', diff saved to https://phabricator.wikimedia.org/P81397 and previous config saved to /var/cache/conftool/dbconfig/20250817-013525-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 1:35 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T01:35:38Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2210 (T400854)', diff saved to https://phabricator.wikimedia.org/P81398 and previous config saved to /var/cache/conftool/dbconfig/20250817-013537-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 1:39 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T01:39:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2210 (T400854)', diff saved to https://phabricator.wikimedia.org/P81399 and previous config saved to /var/cache/conftool/dbconfig/20250817-013922-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 2:24 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T02:24:45Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2210 (T400854)', diff saved to https://phabricator.wikimedia.org/P81402 and previous config saved to /var/cache/conftool/dbconfig/20250817-022445-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 2:25 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T02:25:08Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2219 (T400854)', diff saved to https://phabricator.wikimedia.org/P81403 and previous config saved to /var/cache/conftool/dbconfig/20250817-022508-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 2:28 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T02:28:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2219 (T400854)', diff saved to https://phabricator.wikimedia.org/P81404 and previous config saved to /var/cache/conftool/dbconfig/20250817-022851-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 3:14 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T03:14:14Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2219 (T400854)', diff saved to https://phabricator.wikimedia.org/P81407 and previous config saved to /var/cache/conftool/dbconfig/20250817-031414-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 3:14 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T03:14:37Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2236 (T400854)', diff saved to https://phabricator.wikimedia.org/P81408 and previous config saved to /var/cache/conftool/dbconfig/20250817-031436-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 3:18 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T03:18:25Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T400854)', diff saved to https://phabricator.wikimedia.org/P81409 and previous config saved to /var/cache/conftool/dbconfig/20250817-031824-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 4:03 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T04:03:48Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T400854)', diff saved to https://phabricator.wikimedia.org/P81412 and previous config saved to /var/cache/conftool/dbconfig/20250817-040347-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 4:04 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T04:04:10Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2237 (T400854)', diff saved to https://phabricator.wikimedia.org/P81413 and previous config saved to /var/cache/conftool/dbconfig/20250817-040410-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 4:07 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T04:07:56Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T400854)', diff saved to https://phabricator.wikimedia.org/P81414 and previous config saved to /var/cache/conftool/dbconfig/20250817-040755-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 4:53 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T04:53:19Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T400854)', diff saved to https://phabricator.wikimedia.org/P81417 and previous config saved to /var/cache/conftool/dbconfig/20250817-045318-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 4:57 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T04:57:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2240 (T400854)', diff saved to https://phabricator.wikimedia.org/P81418 and previous config saved to /var/cache/conftool/dbconfig/20250817-045722-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 5:01 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T05:01:08Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T400854)', diff saved to https://phabricator.wikimedia.org/P81419 and previous config saved to /var/cache/conftool/dbconfig/20250817-050107-ladsgroup.json

Stashbot added a comment.Aug 17 2025, 5:46 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-17T05:46:30Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T400854)', diff saved to https://phabricator.wikimedia.org/P81422 and previous config saved to /var/cache/conftool/dbconfig/20250817-054629-ladsgroup.json

Ladsgroup closed this task as Resolved.Aug 18 2025, 10:14 AM
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.
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