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

2022-02-28 Thread Lucas_Werkmeister_WMDE 
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(*) AS total, SUM(eu_aspect 
LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM 
wbc_entity_usage;
+-+--+++
| asof| total| statements | others |
+-+--+++
| 2022-02-28 09:55:39 | 14842746 |   10086742 |   8391 |
+-+--+++
1 row in set (6.068 sec)
  
  Other usages are basically gone; statement usages have stayed around 10 
million; total usages are down to just under 15 million (from over 16 million 
in T296382#7651993 ).
  
MariaDB [hywiki]> SELECT COUNT(*) AS total, SUM(rc_type = 5) FROM 
recentchanges;
++--+
| total  | SUM(rc_type = 5) |
++--+
| 274021 |   210804 |
++--+
1 row in set (0.200 sec)
  
  Total recent changes rows are down from 380k (T296382#7664474 
) to 270k, with 210k 
Wikidata changes (down from 290k).
  
  I think we can call this a success and close this task.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

WORKBOARD
  https://phabricator.wikimedia.org/project/board/5612/

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, karapayneWMDE, Invadibot, maantietaja, 
Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, 
Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-02-01 Thread Lucas_Werkmeister_WMDE 
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| statements | others |
+-+--+++
| 2022-02-01 10:23:10 | 15023372 |   10034429 | 286302 |
+-+--+++
1 row in set (8.064 sec)
  
  Statement usages fairly stable now, other usages still going down, albeit not 
very rapidly anymore.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-31 Thread Lucas_Werkmeister_WMDE 
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 total, SUM(rc_type = 5) FROM 
recentchanges;
++--+
| total  | SUM(rc_type = 5) |
++--+
| 382183 |   292889 |
++--+
1 row in set (0.279 sec)
  
  And it looks like the alias changes are indeed mostly gone and there are 
statement changes instead.
  F34938227: Screenshot from 2022-01-31 17-38-36.png 


TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-31 Thread Lucas_Werkmeister_WMDE 
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| statements | others |
+-+--+++
| 2022-01-31 11:35:28 | 15030757 |   10033840 | 296220 |
+-+--+++
1 row in set (6.776 sec)
  
  Total and statement usages went slightly //down// since Thursday; other 
usages down from 1.2M to 0.3M. Slightly surprising, but not concerning, I’d say.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-27 Thread Lucas_Werkmeister_WMDE 
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(eu_aspect LIKE 'O%') AS others FROM 
wbc_entity_usage;
+-+--++-+
| asof| total| statements | others  |
+-+--++-+
| 2022-01-27 10:31:06 | 16080444 |   10165227 | 1205261 |
+-+--++-+
1 row in set (7.826 sec)

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-27 Thread Ladsgroup 
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://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Ladsgroup
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-26 Thread Lucas_Werkmeister_WMDE 
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;
+-+-++-+
| asof| total   | statements | others  |
+-+-++-+
| 2022-01-26 10:51:05 | 2885789 | 319406 | 1137753 |
+-+-++-+
1 row in set (1.467 sec)
  
  
  
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;
+-+-++-+
| asof| total   | statements | others  |
+-+-++-+
| 2022-01-26 19:51:35 | 2891759 | 325534 | 1137595 |
+-+-++-+
1 row in set (1.468 sec)
  
  I suppose it could’ve burned through an initial set of high-activity pages, 
and the rest is the long tail… we’ll see.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-26 Thread Lucas_Werkmeister_WMDE 
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| statements | others  |
+-+--++-+
| 2022-01-26 10:27:25 | 16209842 |   10125711 | 1375932 |
+-+--++-+
1 row in set (7.655 sec)
  
  If the “other” usages continue to go down at a similar rate, this should 
settle in a bit over three days or so, assuming I’m operating `units` correctly.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-25 Thread Lucas_Werkmeister_WMDE 
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   | statements | others  |
+-+-++-+
| 2022-01-25 16:56:24 | 7441381 |1050128 | 1684320 |
+-+-++-+
1 row in set (2.756 sec)
  
  If we assume that the “other” usages continue decreasing at a constant rate, 
and the “statements” usages increase at a constant rate until the “others” hit 
zero, we can estimate (1050128 - 868357) / (1711896 - 1684320) * 1684320 + 
1050128 = 12152555 **12 million** total statement usages, for ca. 18½ million 
rows in the table in total. That’s substantial (not quite the “much less [than 
65 million]” I had in mind in the task description), but not likely to cause 
any actual problems, I think. hywiki uses more statements per page than I 
expected initially.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-25 Thread Lucas_Werkmeister_WMDE 
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 FROM wbc_entity_usage;
+-++-+
| total   | statements | others  |
+-++-+
| 7286396 | 868357 | 1711896 |
+-++-+
1 row in set (2.391 sec)
  
  Perhaps they’re running a bot over there that frequently purges articles? 
Let’s check back tomorrow or in a few days.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-25 Thread Maintenance_bot 
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, 
Lucas_Werkmeister_WMDE, Lmlmljs, Invadibot, maantietaja, Akuckartz, Nandana, 
lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331, 786, Suran38, 
Biggs657, Lalamarie69, Juan90264, Alter-paule, Beast1978, Un1tY, Hook696, 
Kent7301, joker88john, CucyNoiD, Gaboe420, Giuliamocci, Cpaulf30, Af420, 
Bsandipan, Lewizho99, Maathavan, Neuronton
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-25 Thread Stashbot 
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 
)]] (duration: 00m 50s)

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, 786, Suran38, Biggs657, Invadibot, 
Lalamarie69, maantietaja, Juan90264, Alter-paule, Beast1978, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, lucamauri, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, 
QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-25 Thread gerritbot 
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://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, 786, Suran38, Biggs657, Invadibot, 
Lalamarie69, maantietaja, Juan90264, Alter-paule, Beast1978, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, lucamauri, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, 
QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-25 Thread Lucas_Werkmeister_WMDE 
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 = 5) |
++--+
| 377612 |   287640 |
++--+
1 row in set (0.264 sec)
  
  Most of them seem to be aliases:
  F34930098: Screenshot from 2022-01-25 12-58-28.png 

  Aliases fall under “Other” usage, if I’m not mistaken, so fixing the usage 
tracking should hopefully remove a lot of these pointless recentchanges entries 
(there’s little legitimate reason for Armenian Wikipedia to care about so many 
Russian Aliases, I assume).

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Lmlmljs, 786, Suran38, Biggs657, Invadibot, 
Lalamarie69, maantietaja, Juan90264, Alter-paule, Beast1978, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, lucamauri, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, 
QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-19 Thread noarave 
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-entity-usage-project?orgId=1=hywiki

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

WORKBOARD
  https://phabricator.wikimedia.org/project/board/5612/

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, 786, Suran38, Biggs657, Invadibot, Lalamarie69, 
maantietaja, Juan90264, Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, 
Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, lucamauri, Giuliamocci, 
Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, 
LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-19 Thread gerritbot 
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_Werkmeister_WMDE, 786, Suran38, Biggs657, Invadibot, Lalamarie69, 
maantietaja, Juan90264, Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, 
Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, lucamauri, Giuliamocci, 
Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, 
LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-19 Thread gerritbot 
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.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Invadibot, maantietaja, Akuckartz, Nandana, lucamauri, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-18 Thread noarave 
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, Marostegui, 
Lucas_Werkmeister_WMDE, Invadibot, maantietaja, Akuckartz, Nandana, lucamauri, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2022-01-18 Thread noarave 
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_Werkmeister_WMDE, Invadibot, maantietaja, Akuckartz, Nandana, lucamauri, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2021-12-14 Thread Marostegui 
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, maantietaja, Akuckartz, Nandana, lucamauri, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Addshore, Mbch331, joanna_borun, Devnull, 
lmata, Muchiri124, RhinosF1, Legado_Shulgin, ReaperDawn, Davinaclare77, 
Techguru.pc, Hfbn0, Zppix, Wong128hk, faidon, Jay8g, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2021-11-24 Thread Marostegui 
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, Marostegui, 
Lucas_Werkmeister_WMDE, joanna_borun, Bongo-Cat, Invadibot, Devnull, 
maantietaja, lmata, Muchiri124, Akuckartz, RhinosF1, Legado_Shulgin, 
ReaperDawn, Nandana, lucamauri, Davinaclare77, Techguru.pc, Lahi, Gq86, 
GoranSMilovanovic, Hfbn0, QZanden, LawExplorer, Zppix, _jensen, rosalieper, 
Scott_WUaS, Wong128hk, Wikidata-bugs, aude, faidon, Addshore, Mbch331, Jay8g, 
fgiunchedi, LSobanski, Iflorez, Minhnv-2809, Krenair
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2021-11-24 Thread Lucas_Werkmeister_WMDE 
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");' | expand -t20
table_name  table_rows
recentchanges   242694
wbc_entity_usage4967541

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, joanna_borun, Bongo-Cat, Invadibot, Devnull, LSobanski, 
maantietaja, lmata, Muchiri124, Akuckartz, Iflorez, RhinosF1, Legado_Shulgin, 
ReaperDawn, Nandana, lucamauri, Davinaclare77, Techguru.pc, Lahi, Gq86, 
GoranSMilovanovic, Hfbn0, QZanden, LawExplorer, Minhnv-2809, Zppix, _jensen, 
rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, aude, faidon, Addshore, 
Mbch331, Jay8g, Krenair, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

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

2021-11-24 Thread Lucas_Werkmeister_WMDE 
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 
, we want to remove the 
`wmgWikibaseDisabledUsageAspects` setting for Armenian Wikipedia. This is 
expected to increase the number of rows in the `wbc_entity_usage` to no more 
than 65 million, most likely much less (currently 6.4 million). We should keep 
track of the size of the table after making the change, as well as the size of 
the recentchanges table and the ratio of Wikidata edits there, and check 
on-wiki Lua modules for obvious mistakes if it grows too large.

TASK DETAIL
  https://phabricator.wikimedia.org/T296382

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, joanna_borun, Bongo-Cat, Invadibot, Devnull, LSobanski, 
maantietaja, lmata, Muchiri124, Akuckartz, Iflorez, RhinosF1, Legado_Shulgin, 
ReaperDawn, Nandana, lucamauri, Davinaclare77, Techguru.pc, Lahi, Gq86, 
GoranSMilovanovic, Hfbn0, QZanden, LawExplorer, Minhnv-2809, Zppix, _jensen, 
rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, aude, faidon, Addshore, 
Mbch331, Jay8g, Krenair, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org