[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE closed this task as "Resolved". Lucas_Werkmeister_WMDE moved this task from Tech Verification to Our work done on the Wikidata-Campsite (Team A Hearth 🏰🔥) board. Lucas_Werkmeister_WMDE added a comment. One month later: MariaDB [hywiki]> SELECT NOW() AS asof, COUNT

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. MariaDB [hywiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage; +-+--+++ | asof| total

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. The recentchanges now have 382k rows in total, 293k of which come from Wikibase, which is a fairly minor change compared to T296382#7648565 (378k/288k). MariaDB [hywiki]> SELECT COUNT(*) AS tota

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. MariaDB [hywiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage; +-+--+++ | asof| total

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. Nah, for now I think we can wait a bit for this to settle naturally. Also, I queried the wrong wiki in my last comment 🤦 Current results: MariaDB [hywiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Ladsgroup added a comment. You can write a bot that purges pages that have "O" aspect, that would speed up the clean up. I think I have written one back then in 2016/2017. Do you want me to run it again? TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://pha

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. Hm, not as much change since this morning though. MariaDB [warwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage; +-+-+-

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. MariaDB [hywiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage; +-+--++-+ | asof| tota

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. MariaDB [hywiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage; +-+-++-+ | asof| total

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. Hm, curious that hywiki should already have amassed over 800k statement usages in the few hours since the change was deployed… MariaDB [hywiki]> SELECT COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Maintenance_bot removed a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: noarave, Maintenance_bot Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, Lu

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2022-01-25T12:10:04Z] Synchronized wmf-config/InitialiseSettings.php: Config: [[gerrit:755330|Enable statement usage tracking for Armenian Wikipedia (hywiki) (T296382 )]] (duratio

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

gerritbot added a comment. Change 755330 **merged** by jenkins-bot: [operations/mediawiki-config@master] Enable statement usage tracking for Armenian Wikipedia https://gerrit.wikimedia.org/r/755330 TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. Quick check on the recentchanges table before deployment: 378k rows, 288k of which come from Wikidata. MariaDB [hywiki]> SELECT COUNT(*) AS total, SUM(rc_type = 5) FROM recentchanges; ++--+ | total | SUM(rc_type =

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

noarave moved this task from Doing to Peer Review on the Wikidata-Campsite (Team A Hearth 🏰🔥) board. noarave added a comment. After this is deployed we should make sure data is being tracked under "Statement Flags" in the hywiki dashboard: https://grafana.wikimedia.org/d/00176/wikidata-e

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

gerritbot added a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: noarave, gerritbot Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, Lucas_Werkmeiste

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

gerritbot added a comment. Change 755330 had a related patch set uploaded (by Noa wmde; author: Noa wmde): [operations/mediawiki-config@master] Enable statement usage tracking for Armenian Wikipedia https://gerrit.wikimedia.org/r/755330 TASK DETAIL https://phabricator.wikimedia.o

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

noarave claimed this task. Restricted Application added a project: User-Noarave. TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: noarave Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Maro

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

noarave added a project: Wikidata-Campsite (Team A Hearth 🏰🔥). TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: noarave Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, Lucas_Wer

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Marostegui removed a project: SRE. TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, Lucas_Werkmeister_WMDE, Invadibot,

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Marostegui edited projects, added Data-Persistence (Consultation); removed DBA. TASK DETAIL https://phabricator.wikimedia.org/T296382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Ma

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE added a comment. 2021-11-24: lucaswerkmeister-wmde@stat1007:~$ sudo -u analytics-wmde analytics-mysql hywiki <<< 'SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = "hywiki" AND table_name IN ("wbc_entity_usage", "recentchanges");'

[Wikidata-bugs] [Maniphest] T296382: Enable statement usage tracking on hywiki

Lucas_Werkmeister_WMDE created this task. Lucas_Werkmeister_WMDE added projects: MediaWiki-extensions-WikibaseClient, Wikidata, wdwb-tech, DBA, SRE. TASK DESCRIPTION As agreed in T188730#7461581 and T188730#7525888