Page MenuHomePhabricator
Create Task
Maniphest T380449

Optimize two echo tables in x1
Open, MediumPublic
Actions

Description

Now that T308084: Reduce DB space used by Echo notifications is done, we need to optimize echo_target_page and echo_event in every wiki db in x1

Related Objects

Event Timeline

Ladsgroup created this task.Thu, Nov 21, 9:35 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptThu, Nov 21, 9:35 AM
ABran-WMF triaged this task as Medium priority.Fri, Nov 22, 7:42 AM
ABran-WMF moved this task from Triage to Ready on the DBA board.
CodeReviewBot added a project: Patch-For-Review.Mon, Nov 25, 11:43 AM

ladsgroup opened https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/25

Add optimize_echo_events.py

Stashbot added a comment.Mon, Nov 25, 11:47 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T11:47:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1179 (T380449)', diff saved to https://phabricator.wikimedia.org/P71125 and previous config saved to /var/cache/conftool/dbconfig/20241125-114651-ladsgroup.json

Ladsgroup added a comment.Mon, Nov 25, 12:59 PM

320GB down:
https://grafana.wikimedia.org/d/000000377/host-overview?orgId=1&var-server=db1179&var-datasource=thanos&var-cluster=mysql&viewPanel=28&from=1732531593395&to=1732539500217

grafik.png (812×1 px, 37 KB)

Ladsgroup mentioned this in rSCHCH25b7c1944548: Add optimize_echo_events.py.Mon, Nov 25, 1:14 PM
Stashbot added a comment.Mon, Nov 25, 3:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T15:11:04Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1224 (T380449)', diff saved to https://phabricator.wikimedia.org/P71131 and previous config saved to /var/cache/conftool/dbconfig/20241125-151103-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 3:33 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T15:33:54Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T380449)', diff saved to https://phabricator.wikimedia.org/P71132 and previous config saved to /var/cache/conftool/dbconfig/20241125-153354-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 4:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T16:19:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T380449)', diff saved to https://phabricator.wikimedia.org/P71138 and previous config saved to /var/cache/conftool/dbconfig/20241125-161915-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 5:35 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T17:35:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1237 (T380449)', diff saved to https://phabricator.wikimedia.org/P71140 and previous config saved to /var/cache/conftool/dbconfig/20241125-173511-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 6:26 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T18:26:04Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1237 (T380449)', diff saved to https://phabricator.wikimedia.org/P71141 and previous config saved to /var/cache/conftool/dbconfig/20241125-182603-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 7:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T19:11:25Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1237 (T380449)', diff saved to https://phabricator.wikimedia.org/P71144 and previous config saved to /var/cache/conftool/dbconfig/20241125-191124-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 8:00 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T20:00:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2115 (T380449)', diff saved to https://phabricator.wikimedia.org/P71147 and previous config saved to /var/cache/conftool/dbconfig/20241125-200031-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 8:53 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T20:53:21Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2115 (T380449)', diff saved to https://phabricator.wikimedia.org/P71149 and previous config saved to /var/cache/conftool/dbconfig/20241125-205320-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 9:38 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T21:38:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2115 (T380449)', diff saved to https://phabricator.wikimedia.org/P71152 and previous config saved to /var/cache/conftool/dbconfig/20241125-213841-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 9:39 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T21:39:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2131 (T380449)', diff saved to https://phabricator.wikimedia.org/P71153 and previous config saved to /var/cache/conftool/dbconfig/20241125-213904-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 10:04 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T22:04:06Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2131 (T380449)', diff saved to https://phabricator.wikimedia.org/P71154 and previous config saved to /var/cache/conftool/dbconfig/20241125-220406-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 10:49 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T22:49:27Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2131 (T380449)', diff saved to https://phabricator.wikimedia.org/P71157 and previous config saved to /var/cache/conftool/dbconfig/20241125-224927-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 10:49 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T22:49:49Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2191 (T380449)', diff saved to https://phabricator.wikimedia.org/P71158 and previous config saved to /var/cache/conftool/dbconfig/20241125-224949-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 11:10 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T23:10:30Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2191 (T380449)', diff saved to https://phabricator.wikimedia.org/P71159 and previous config saved to /var/cache/conftool/dbconfig/20241125-231026-ladsgroup.json

Stashbot added a comment.Mon, Nov 25, 11:55 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-25T23:55:47Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2191 (T380449)', diff saved to https://phabricator.wikimedia.org/P71162 and previous config saved to /var/cache/conftool/dbconfig/20241125-235547-ladsgroup.json

Stashbot added a comment.Tue, Nov 26, 3:41 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-26T03:40:44Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2215 (T380449)', diff saved to https://phabricator.wikimedia.org/P71163 and previous config saved to /var/cache/conftool/dbconfig/20241126-034040-ladsgroup.json

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