[Wikidata-bugs] [Maniphest] T296384: Enable statement usage tracking on cebwiki

[Stashbot]

Stashbot added a comment.


  Mentioned in SAL (#wikimedia-operations) [2022-09-29T13:20:33Z] 
 Finished scap: Backport for 
[[gerrit:836227|Remove wmgEntityUsageModifierLimitsStatement on cebwiki 
(T296384 )]] (duration: 05m 23s)

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

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

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 
Lmlmljs, 786, Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, 
Alter-paule, Beast1978, ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Stashbot]

Stashbot added a comment.


  Mentioned in SAL (#wikimedia-operations) [2022-09-29T13:15:33Z] 
 lucaswerkmeister-wmde and 
lucaswerkmeister-wmde: Backport for [[gerrit:836227|Remove 
wmgEntityUsageModifierLimitsStatement on cebwiki (T296384 
)]] synced to the testservers: 
mwdebug1002.eqiad.wmnet, mwdebug1001.eqiad.wmnet, mwdebug2002.codfw.wmnet, 
mwdebug2001.codfw.wmnet

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

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

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 
Lmlmljs, 786, Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, 
Alter-paule, Beast1978, ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Stashbot]

Stashbot added a comment.


  Mentioned in SAL (#wikimedia-operations) [2022-09-29T13:15:10Z] 
 Started scap: Backport for 
[[gerrit:836227|Remove wmgEntityUsageModifierLimitsStatement on cebwiki 
(T296384 )]]

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

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

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 
Lmlmljs, 786, Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, 
Alter-paule, Beast1978, ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a comment.


  Change 836227 **merged** by jenkins-bot:
  
  [operations/mediawiki-config@master] Remove 
wmgEntityUsageModifierLimitsStatement on cebwiki
  
  https://gerrit.wikimedia.org/r/836227

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

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

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 
Lmlmljs, 786, Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, 
Alter-paule, Beast1978, ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a project: Patch-For-Review.

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

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

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 
Lmlmljs, 786, Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, 
Alter-paule, Beast1978, ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a comment.


  Change 836227 had a related patch set uploaded (by Lucas Werkmeister (WMDE); 
author: Lucas Werkmeister (WMDE)):
  
  [operations/mediawiki-config@master] Remove 
wmgEntityUsageModifierLimitsStatement on cebwiki
  
  https://gerrit.wikimedia.org/r/836227

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

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

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  Alright, the script finished and the remaining 4256 “other” usages are 
probably real ones.
  
  Also, it looks like barely any pages actually have enough statement usages to 
hit the customized, lower entity usage modifier limit:
  
MariaDB [cebwiki]> SELECT NOW() AS asof, SUM(eu_aspect LIKE 'C.%') AS 
modifier, SUM(eu_aspect = 'C') AS general FROM wbc_entity_usage;
+-+--+-+
| asof| modifier | general |
+-+--+-+
| 2022-09-13 10:18:21 | 17754901 | 138 |
+-+--+-+
1 row in set (9.446 sec)
  
  So I suggest we remove that from cebwiki again (now that we know the entity 
usage table won’t explode from too many statement usages), and leave it at the 
default for all other wikis (33 instead of 10). @Ladsgroup does that sound okay?

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  I forgot that there can still be legitimate “other” usages (I confused it 
with “X”, which we really expect to not exist at all). And most of the 
remaining “other” usages come from two pages that really just have a lot of 
those usages:
  
MariaDB [cebwiki]> SELECT eu_page_id, COUNT(*) FROM wbc_entity_usage WHERE 
eu_aspect LIKE 'O%' GROUP BY eu_page_id ORDER BY COUNT(*) DESC LIMIT 3;
++--+
| eu_page_id | COUNT(*) |
++--+
|   10942920 | 1737 |
|9869118 | 1737 |
|  46428 |   17 |
  
  So I hard-coded the script to skip those page IDs and am letting it run for 
the remaining pages now. And once that’s done, I think we can call this 
finished, even if a few “other” usages will remain.

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  The job queue has recovered and there are still “other” usages left, so I’ll 
resume the script:
  
MariaDB [cebwiki]> 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-09-13 08:59:18 | 28016659 |   17755039 |   4272 |
+-+--+++
1 row in set (9.662 sec)

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  So far, usages are only going down very slowly.
  
(venv) lucaswerkmeister-wmde@tools-sgebastion-10:~/purge-other-usages$ 
./purge-other-usages ceb.wikipedia.org '' 0
Processed up to P9395, 10621606.
Processed up to Q1020685, 9869118.
Processed up to Q1020939, 55358.
Processed up to Q103825, 10942920.
Processed up to Q103958, 10942920.
Processed up to Q104071, 10942920.
Processed up to Q106790, 10942920.
Processed up to Q107454, 9869118.
Processed up to Q107559, 9869118.
Processed up to Q111372, 10942920.
Processed up to Q111677, 10942920.
Processed up to Q12692, 10942920.
Processed up to Q12853, 9869118.
Processed up to Q12893, 9869118.
^CTraceback (most recent call last):
  File "./purge-other-usages", line 79, in 
time.sleep(75)
KeyboardInterrupt
  
  
  
MariaDB [cebwiki]> 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-09-12 10:24:58 | 28016613 |   17755028 |   4249 |
+-+--+++
1 row in set (9.862 sec)
  
  I also notice that `wikibase-addUsagesForPage` jobs are currently backlogged 
(Grafana 
):
  F35517599: image.png 
  So I’ve stopped the script for now (KeyboardInterrupt above) – I assume the 
number previously wasn’t going down due to this backlog, so let’s let it 
recover first.

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  The cleanup of “other” usages slowed down a bit and now seems to have come at 
a halt:
  
MariaDB [cebwiki]> 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-09-12 09:12:07 | 28016614 |   17755028 |   4250 |
+-+--+++
1 row in set (9.757 sec)
MariaDB [cebwiki]> 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-09-12 09:43:13 | 28016614 |   17755028 |   4250 |
+-+--+++
1 row in set (9.852 sec)
  
  I’ll run purge-other-usages 
 and see if that gets 
rid of the rest. Should take about three hours.

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


MariaDB [cebwiki]> 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-08-31 11:01:52 | 28402531 |   17755452 | 388666 |
+-+--+++
1 row in set (9.727 sec)
  
  If the “other” usages continue to evaporate at a comparable rate, they should 
be gone by the end of the week:
  
$ units
Currency exchange rates from FloatRates (USD base) on 2020-11-15 
3677 units, 109 prefixes, 114 nonlinear units

You have: 388666 / ((551913 - 388666) / 24.5 hours)
You want: time
2 day + 10 hr + 19 min + 50.63505 sec

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  Updated numbers:
  
MariaDB [cebwiki]> 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-08-29 10:37:54 | 28565735 |   17755420 | 551913 |
+-+--+++
1 row in set (9.765 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(rc_type = 5 
/* RC_EXTERNAL */) AS fromwikidata FROM recentchanges;
+-++--+
| asof| total  | fromwikidata |
+-++--+
| 2022-08-29 10:38:08 | 170182 |   166925 |
+-++--+
1 row in set (0.102 sec)
  
  So statement usages have mostly replaced “other” usages, with a total of 28½ 
million rows, which is indeed “no more than 60 million, most likely much less”.

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

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, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Lydia_Pintscher]

Lydia_Pintscher closed this task as "Resolved".
Lydia_Pintscher moved this task from Tech Verification to Our work done on the 
Wikidata Dev Team (Sprint-∞) board.
Lydia_Pintscher added a comment.


  \o/

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

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

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

To: noarave, Lydia_Pintscher
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, 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] T296384: Enable statement usage tracking on cebwiki

[Maintenance_bot]

Maintenance_bot removed a project: Patch-For-Review.

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

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

To: noarave, Maintenance_bot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331, Hellket777, 786, Biggs657, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  Oh, and I tested it for an individual page ('Aria 
, info 
) with a null 
edit:
  F35382006: Screenshot 2022-08-02 at 15-54-09 Information for 'Aria - 
Wikipedia.png  ⇒ F35382001: 
Screenshot 2022-08-02 at 15-54-18 Information for 'Aria - Wikipedia.png 


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

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, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE moved this task from Peer Review to Tech Verification on 
the Wikidata Dev Team (Sprint-♾) board.
Lucas_Werkmeister_WMDE added a comment.


  Deployed; we should start to see the impact over the coming days and weeks, 
as cebwiki pages gradually get reparsed and have their usage tracking updated.
  
  Since we can’t expect that to happen organically for all pages, at some point 
we’ll want to actively purge them. We could use the script 
 I prepared for T296383 
; alternatively (or in addition), we 
could trigger a recursive purge for {{paghimo ni bot}} 
 via the API, which 
should effectively purge most pages on the wiki (it has 5½ million 
transclusions).

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

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

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, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Stashbot]

Stashbot added a comment.


  Mentioned in SAL (#wikimedia-operations) [2022-08-02T13:40:37Z] 
 Synchronized 
wmf-config/InitialiseSettings.php: Config: [[gerrit:754933|Enable usage 
tracking for statement for cebwiki (T296384 
)]] – expected to gradually increase 
number of wbc_entity_usage and probably recentchanges rows on cebwiki, but not 
too much, see task for details (duration: 03m 06s)

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

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

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a comment.


  Change 754933 **merged** by jenkins-bot:
  
  [operations/mediawiki-config@master] Enable usage tracking for statement for 
cebwiki
  
  https://gerrit.wikimedia.org/r/754933

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

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

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Stashbot]

Stashbot added a comment.


  Mentioned in SAL (#wikimedia-operations) [2022-08-02T13:34:34Z] 
 Synchronized wmf-config/Wikibase.php: 
Config: [[gerrit:754937|Introduce $wmgEntityUsageModifierLimitsStatement 
(T296384 )]] (2/2) (duration: 03m 
21s)

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

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

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Stashbot]

Stashbot added a comment.


  Mentioned in SAL (#wikimedia-operations) [2022-08-02T13:30:59Z] 
 Synchronized 
wmf-config/InitialiseSettings.php: Config: [[gerrit:754937|Introduce 
$wmgEntityUsageModifierLimitsStatement (T296384 
)]] (1/2) (duration: 03m 16s)

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

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

To: noarave, Stashbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a comment.


  Change 754937 **merged** by jenkins-bot:
  
  [operations/mediawiki-config@master] Introduce 
$wmgEntityUsageModifierLimitsStatement
  
  https://gerrit.wikimedia.org/r/754937

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

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

To: noarave, gerritbot
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  Updated baseline on the number of entity usage rows:
  
MariaDB [cebwiki]> 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-08-02 10:29:47 | 15038456 |  0 | 4780944 |
+-+--++-+
1 row in set (16.876 sec)
  
  And also on the amount of Wikidata recentchanges entries:
  
MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(rc_type = 5 
/* RC_EXTERNAL */) AS fromwikidata FROM recentchanges;
+-++--+
| asof| total  | fromwikidata |
+-++--+
| 2022-08-02 10:34:10 | 144266 |   136686 |
+-++--+
1 row in set (0.070 sec)

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

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, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Manuel]

Manuel edited projects, added Wikidata Dev Team (Sprint-♾); removed 
Wikidata-Campsite (Team A Hearth ).

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

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

To: noarave, Manuel
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui, 
Lucas_Werkmeister_WMDE, Hellket777, Astuthiodit_1, Lmlmljs, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, 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, 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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  Now that hywiki and warwiki are done, I think we can move onto this wiki 
soon. Here’s an update on the baseline:
  
MariaDB [cebwiki]> 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-03-09 16:16:25 | 15229870 |  0 | 4797898 |
+-+--++-+
1 row in set (6.703 sec)

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

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, Fernandobacasegua34, Lmlmljs, 786, Suran38, Biggs657, 
karapayneWMDE, 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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a comment.


  Change 754937 had a related patch set uploaded (by Noa wmde; author: Noa 
wmde):
  
  [operations/mediawiki-config@master] Introduce 
$wmgEntityUsageModifierLimitsStatement
  
  https://gerrit.wikimedia.org/r/754937

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

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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a project: Patch-For-Review.

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

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] T296384: Enable statement usage tracking on cebwiki

[gerritbot]

gerritbot added a comment.


  Change 754933 had a related patch set uploaded (by Noa wmde; author: Noa 
wmde):
  
  [operations/mediawiki-config@master] Enable usage tracking for statement for 
cebwiki
  
  https://gerrit.wikimedia.org/r/754933

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

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] T296384: Enable statement usage tracking on cebwiki

[noarave]

noarave claimed this task.
Restricted Application added a project: User-Noarave.

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

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] T296384: Enable statement usage tracking on cebwiki

[noarave]

noarave added a project: Wikidata-Campsite (Team A Hearth ).

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

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] T296384: Enable statement usage tracking on cebwiki

[noarave]

noarave updated the task description.

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

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] T296384: Enable statement usage tracking on cebwiki

[Marostegui]

Marostegui removed a project: SRE.

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

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] T296384: Enable statement usage tracking on cebwiki

[Marostegui]

Marostegui edited projects, added Data-Persistence (Consultation); removed DBA.

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

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] T296384: Enable statement usage tracking on cebwiki

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.


  2021-11-24:
  
lucaswerkmeister-wmde@stat1007:~$ sudo -u analytics-wmde analytics-mysql 
cebwiki <<< 'SELECT table_name, table_rows FROM information_schema.tables WHERE 
table_schema = "cebwiki" AND table_name IN ("wbc_entity_usage", 
"recentchanges");' | expand -t20
table_name  table_rows
recentchanges   841431
wbc_entity_usage13725390

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

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] T296384: Enable statement usage tracking on cebwiki

[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 Cebuano Wikipedia, and set 
`$wgWBClientSettings['entityUsageModifierLimits']['C']` to 10 (instead of the 
default 33). This is expected to increase the number of rows in the 
`wbc_entity_usage` to no more than 60 million, most likely much less (currently 
14.6 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/T296384

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