Page MenuHomePhabricator
Create Task
Maniphest T357189

Drop iwl_prefix_from_title from iwlinks
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/997425/4/maintenance/archives/patch-iwlinks-drop-iwl_prefix_from_title.sql
    1. Maybe add an optimize table iwlinks; as well.
  2. Where to run those changes: all
  3. When to run those changes: At 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: The 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 is needed
  • s1 done
  • s2 done
  • s3 done
  • s4 done
  • s5 done
  • s6 done
  • s7 done
  • s8 done
  • cloudlabsdb

Related Objects
Search...

StatusSubtypeAssignedTask
 OpenNoneT343131 Commons database is growing way too fast
 ResolvedABran-WMFT357189 Drop iwl_prefix_from_title from iwlinks

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Mar 4 2024, 7:16 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T19:16:02Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T357189)', diff saved to https://phabricator.wikimedia.org/P58396 and previous config saved to /var/cache/conftool/dbconfig/20240304-191601-arnaudb.json

Stashbot added a comment.Mar 4 2024, 8:01 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T20:01:21Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T357189)', diff saved to https://phabricator.wikimedia.org/P58400 and previous config saved to /var/cache/conftool/dbconfig/20240304-200121-arnaudb.json

Stashbot added a comment.Mar 4 2024, 8:02 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T20:02:08Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2116 (T357189)', diff saved to https://phabricator.wikimedia.org/P58401 and previous config saved to /var/cache/conftool/dbconfig/20240304-200143-arnaudb.json

Stashbot added a comment.Mar 4 2024, 9:02 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T21:02:15Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T357189)', diff saved to https://phabricator.wikimedia.org/P58403 and previous config saved to /var/cache/conftool/dbconfig/20240304-210214-arnaudb.json

Stashbot added a comment.Mar 4 2024, 9:47 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T21:47:35Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T357189)', diff saved to https://phabricator.wikimedia.org/P58406 and previous config saved to /var/cache/conftool/dbconfig/20240304-214734-arnaudb.json

Stashbot added a comment.Mar 4 2024, 9:47 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T21:47:58Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2130 (T357189)', diff saved to https://phabricator.wikimedia.org/P58407 and previous config saved to /var/cache/conftool/dbconfig/20240304-214757-arnaudb.json

Stashbot added a comment.Mar 4 2024, 9:56 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T21:56:27Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T357189)', diff saved to https://phabricator.wikimedia.org/P58408 and previous config saved to /var/cache/conftool/dbconfig/20240304-215626-arnaudb.json

Stashbot added a comment.Mar 4 2024, 10:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T22:41:46Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T357189)', diff saved to https://phabricator.wikimedia.org/P58411 and previous config saved to /var/cache/conftool/dbconfig/20240304-224145-arnaudb.json

Stashbot added a comment.Mar 4 2024, 10:45 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T22:45:50Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2145 (T357189)', diff saved to https://phabricator.wikimedia.org/P58412 and previous config saved to /var/cache/conftool/dbconfig/20240304-224550-arnaudb.json

Stashbot added a comment.Mar 4 2024, 11:28 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-04T23:28:27Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T357189)', diff saved to https://phabricator.wikimedia.org/P58413 and previous config saved to /var/cache/conftool/dbconfig/20240304-232826-arnaudb.json

Stashbot added a comment.Mar 5 2024, 12:13 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T00:13:46Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T357189)', diff saved to https://phabricator.wikimedia.org/P58416 and previous config saved to /var/cache/conftool/dbconfig/20240305-001345-arnaudb.json

Stashbot added a comment.Mar 5 2024, 12:14 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T00:14:09Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2146 (T357189)', diff saved to https://phabricator.wikimedia.org/P58417 and previous config saved to /var/cache/conftool/dbconfig/20240305-001408-arnaudb.json

Stashbot added a comment.Mar 5 2024, 12:19 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T00:19:19Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T357189)', diff saved to https://phabricator.wikimedia.org/P58418 and previous config saved to /var/cache/conftool/dbconfig/20240305-001918-arnaudb.json

Stashbot added a comment.Mar 5 2024, 1:04 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T01:04:38Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T357189)', diff saved to https://phabricator.wikimedia.org/P58421 and previous config saved to /var/cache/conftool/dbconfig/20240305-010438-arnaudb.json

Stashbot added a comment.Mar 5 2024, 1:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T01:05:00Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2153 (T357189)', diff saved to https://phabricator.wikimedia.org/P58422 and previous config saved to /var/cache/conftool/dbconfig/20240305-010459-arnaudb.json

Stashbot added a comment.Mar 5 2024, 1:10 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T01:10:08Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T357189)', diff saved to https://phabricator.wikimedia.org/P58423 and previous config saved to /var/cache/conftool/dbconfig/20240305-011008-arnaudb.json

Stashbot added a comment.Mar 5 2024, 1:55 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T01:55:27Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T357189)', diff saved to https://phabricator.wikimedia.org/P58426 and previous config saved to /var/cache/conftool/dbconfig/20240305-015527-arnaudb.json

Stashbot added a comment.Mar 5 2024, 1:55 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T01:55:51Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2170 (T357189)', diff saved to https://phabricator.wikimedia.org/P58427 and previous config saved to /var/cache/conftool/dbconfig/20240305-015550-arnaudb.json

Stashbot added a comment.Mar 5 2024, 2:00 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T02:00:50Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T357189)', diff saved to https://phabricator.wikimedia.org/P58428 and previous config saved to /var/cache/conftool/dbconfig/20240305-020049-arnaudb.json

Stashbot added a comment.Mar 5 2024, 2:46 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T02:46:09Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T357189)', diff saved to https://phabricator.wikimedia.org/P58431 and previous config saved to /var/cache/conftool/dbconfig/20240305-024608-arnaudb.json

Stashbot added a comment.Mar 5 2024, 2:46 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T02:46:58Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2173 (T357189)', diff saved to https://phabricator.wikimedia.org/P58432 and previous config saved to /var/cache/conftool/dbconfig/20240305-024657-arnaudb.json

Stashbot added a comment.Mar 5 2024, 2:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T02:52:13Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T357189)', diff saved to https://phabricator.wikimedia.org/P58433 and previous config saved to /var/cache/conftool/dbconfig/20240305-025212-arnaudb.json

Stashbot added a comment.Mar 5 2024, 3:37 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T03:37:33Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T357189)', diff saved to https://phabricator.wikimedia.org/P58436 and previous config saved to /var/cache/conftool/dbconfig/20240305-033732-arnaudb.json

Stashbot added a comment.Mar 5 2024, 3:37 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T03:37:55Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2174 (T357189)', diff saved to https://phabricator.wikimedia.org/P58437 and previous config saved to /var/cache/conftool/dbconfig/20240305-033755-arnaudb.json

Stashbot added a comment.Mar 5 2024, 3:46 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T03:46:14Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T357189)', diff saved to https://phabricator.wikimedia.org/P58438 and previous config saved to /var/cache/conftool/dbconfig/20240305-034614-arnaudb.json

Stashbot added a comment.Mar 5 2024, 4:31 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T04:31:33Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T357189)', diff saved to https://phabricator.wikimedia.org/P58441 and previous config saved to /var/cache/conftool/dbconfig/20240305-043133-arnaudb.json

Stashbot added a comment.Mar 5 2024, 4:31 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T04:31:56Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2176 (T357189)', diff saved to https://phabricator.wikimedia.org/P58442 and previous config saved to /var/cache/conftool/dbconfig/20240305-043155-arnaudb.json

Stashbot added a comment.Mar 5 2024, 4:37 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T04:37:19Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T357189)', diff saved to https://phabricator.wikimedia.org/P58443 and previous config saved to /var/cache/conftool/dbconfig/20240305-043718-arnaudb.json

Stashbot added a comment.Mar 5 2024, 5:22 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T05:22:38Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T357189)', diff saved to https://phabricator.wikimedia.org/P58446 and previous config saved to /var/cache/conftool/dbconfig/20240305-052237-arnaudb.json

Stashbot added a comment.Mar 5 2024, 5:23 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T05:23:00Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2188 (T357189)', diff saved to https://phabricator.wikimedia.org/P58447 and previous config saved to /var/cache/conftool/dbconfig/20240305-052259-arnaudb.json

Stashbot added a comment.Mar 5 2024, 5:27 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T05:27:42Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T357189)', diff saved to https://phabricator.wikimedia.org/P58448 and previous config saved to /var/cache/conftool/dbconfig/20240305-052741-arnaudb.json

Stashbot added a comment.Mar 5 2024, 6:13 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T06:13:01Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T357189)', diff saved to https://phabricator.wikimedia.org/P58451 and previous config saved to /var/cache/conftool/dbconfig/20240305-061300-arnaudb.json

Stashbot added a comment.Mar 5 2024, 8:30 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T08:30:28Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db1235 (T357189)', diff saved to https://phabricator.wikimedia.org/P58452 and previous config saved to /var/cache/conftool/dbconfig/20240305-083028-arnaudb.json

Stashbot added a comment.Mar 5 2024, 8:36 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T08:36:22Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T357189)', diff saved to https://phabricator.wikimedia.org/P58453 and previous config saved to /var/cache/conftool/dbconfig/20240305-083621-arnaudb.json

Stashbot added a comment.Mar 5 2024, 9:21 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T09:21:41Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T357189)', diff saved to https://phabricator.wikimedia.org/P58457 and previous config saved to /var/cache/conftool/dbconfig/20240305-092140-arnaudb.json

Stashbot added a comment.Mar 5 2024, 9:22 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T09:22:02Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2116 (T357189)', diff saved to https://phabricator.wikimedia.org/P58458 and previous config saved to /var/cache/conftool/dbconfig/20240305-092202-arnaudb.json

Stashbot added a comment.Mar 5 2024, 9:27 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T09:27:22Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T357189)', diff saved to https://phabricator.wikimedia.org/P58459 and previous config saved to /var/cache/conftool/dbconfig/20240305-092721-arnaudb.json

Stashbot added a comment.Mar 5 2024, 10:12 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-05T10:12:41Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T357189)', diff saved to https://phabricator.wikimedia.org/P58462 and previous config saved to /var/cache/conftool/dbconfig/20240305-101241-arnaudb.json

Stashbot added a comment.Mar 6 2024, 12:55 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-06T12:55:30Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db2218 (T357189)', diff saved to https://phabricator.wikimedia.org/P58582 and previous config saved to /var/cache/conftool/dbconfig/20240306-125529-arnaudb.json

Stashbot added a comment.Mar 6 2024, 1:05 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-06T13:05:42Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2218 (T357189)', diff saved to https://phabricator.wikimedia.org/P58583 and previous config saved to /var/cache/conftool/dbconfig/20240306-130542-arnaudb.json

Stashbot added a comment.Mar 6 2024, 1:51 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-06T13:51:03Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2218 (T357189)', diff saved to https://phabricator.wikimedia.org/P58587 and previous config saved to /var/cache/conftool/dbconfig/20240306-135102-arnaudb.json

ABran-WMF updated the task description. (Show Details)Mar 7 2024, 11:00 AM

will run on labsdb and then disable optimize table iwlinks; to run on all masters

ABran-WMF updated the task description. (Show Details)Mar 7 2024, 1:29 PM
ABran-WMF updated the task description. (Show Details)Mar 7 2024, 1:35 PM
ABran-WMF updated the task description. (Show Details)
ABran-WMF updated the task description. (Show Details)Mar 7 2024, 2:28 PM
ABran-WMF updated the task description. (Show Details)Mar 7 2024, 2:30 PM
ABran-WMF updated the task description. (Show Details)
Stashbot added a comment.Mar 7 2024, 2:33 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-07T14:33:37Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Depooling db1167 (T357189)', diff saved to https://phabricator.wikimedia.org/P58644 and previous config saved to /var/cache/conftool/dbconfig/20240307-143336-arnaudb.json

Stashbot added a comment.Mar 7 2024, 3:32 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-07T15:32:00Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T357189)', diff saved to https://phabricator.wikimedia.org/P58647 and previous config saved to /var/cache/conftool/dbconfig/20240307-153200-arnaudb.json

Stashbot added a comment.Mar 7 2024, 4:17 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-07T16:17:20Z] <arnaudb@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T357189)', diff saved to https://phabricator.wikimedia.org/P58650 and previous config saved to /var/cache/conftool/dbconfig/20240307-161720-arnaudb.json

ABran-WMF updated the task description. (Show Details)Mar 7 2024, 4:19 PM
ABran-WMF updated the task description. (Show Details)
ABran-WMF closed this task as Resolved.Mar 7 2024, 4:21 PM
Maintenance_bot moved this task from In progress to Done on the DBA board.Mar 7 2024, 4:29 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