Page MenuHomePhabricator
Create Task
Maniphest T291276

Get metrics of wb_changes table
Closed, ResolvedPublic
Actions

Description

We need to get metrics on median of timestamp of change rows of in wb_changes table and also the oldest timestamp in the table live.

This is mostly blocked on T240685: MediaWiki Prometheus support

Details

SubjectRepoBranchLines +/-
Fix metrics building in wb_changesanalytics/wmde/scriptsproduction+2 -2
Fix metrics building in wb_changesanalytics/wmde/scriptsmaster+2 -2
Add script to get some data out of wb_changesanalytics/wmde/scriptsproduction+29 -0
Add script to get some data out of wb_changesanalytics/wmde/scriptsmaster+29 -0
Customize query in gerrit

Related Objects

Event Timeline

Ladsgroup created this task.Sep 17 2021, 4:16 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 17 2021, 4:16 PM
gerritbot added a comment.Sep 24 2021, 8:21 PM

Change 723613 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[analytics/wmde/scripts@master] [WIP] Add script to get some data out of wb_changes

https://gerrit.wikimedia.org/r/723613

gerritbot added a project: Patch-For-Review.Sep 24 2021, 8:21 PM
Michael moved this task from Backlog to Doing on the Wikibase change dispatching scripts to jobs board.Sep 27 2021, 7:59 AM
gerritbot added a comment.Oct 1 2021, 1:46 PM

Change 723613 merged by jenkins-bot:

[analytics/wmde/scripts@master] Add script to get some data out of wb_changes

https://gerrit.wikimedia.org/r/723613

Ladsgroup mentioned this in rADESe002d5e9539f: Add script to get some data out of wb_changes.Oct 1 2021, 1:48 PM
Maintenance_bot removed a project: Patch-For-Review.Oct 1 2021, 2:10 PM
gerritbot added a comment.Oct 4 2021, 7:14 AM

Change 725416 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[analytics/wmde/scripts@production] Add script to get some data out of wb_changes

https://gerrit.wikimedia.org/r/725416

gerritbot added a project: Patch-For-Review.Oct 4 2021, 7:14 AM

Change 725416 merged by jenkins-bot:

[analytics/wmde/scripts@production] Add script to get some data out of wb_changes

https://gerrit.wikimedia.org/r/725416

Ladsgroup mentioned this in rADES6f19b1fdb458: Add script to get some data out of wb_changes.Oct 4 2021, 7:24 AM
gerritbot added a comment.Oct 4 2021, 8:02 AM

Change 725693 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[analytics/wmde/scripts@master] Fix metrics building in wb_changes

https://gerrit.wikimedia.org/r/725693

Ladsgroup moved this task from Doing to Needs Review on the Wikibase change dispatching scripts to jobs board.Oct 4 2021, 8:02 AM
gerritbot added a comment.Oct 4 2021, 9:41 AM

Change 725693 merged by jenkins-bot:

[analytics/wmde/scripts@master] Fix metrics building in wb_changes

https://gerrit.wikimedia.org/r/725693

Ladsgroup mentioned this in rADES19464b942e00: Fix metrics building in wb_changes.Oct 4 2021, 9:43 AM
gerritbot added a comment.Oct 4 2021, 12:25 PM

Change 725425 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[analytics/wmde/scripts@production] Fix metrics building in wb_changes

https://gerrit.wikimedia.org/r/725425

gerritbot added a comment.Oct 4 2021, 12:26 PM

Change 725425 merged by jenkins-bot:

[analytics/wmde/scripts@production] Fix metrics building in wb_changes

https://gerrit.wikimedia.org/r/725425

Ladsgroup mentioned this in rADES08ad66883754: Fix metrics building in wb_changes.Oct 4 2021, 12:27 PM
Ladsgroup moved this task from Needs Review to Done on the Wikibase change dispatching scripts to jobs board.Oct 4 2021, 12:48 PM
Michael removed a project: Patch-For-Review.Oct 5 2021, 3:29 PM
Michael mentioned this in T291616: add analytics script to track stats about wb_changes table.Oct 8 2021, 2:25 PM
Michael added a comment.Oct 22 2021, 5:37 PM

This has been implemented with an analytics script reading from a replica. Further work on this after T240685 is done, might happen in context of T291616

Michael closed this task as Resolved.Oct 22 2021, 5:38 PM
Michael claimed this task.
Restricted Application added a project: User-Michael. · View Herald TranscriptOct 22 2021, 5:38 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