[Wikidata-bugs] [Maniphest] T274413: Retrieve metric "% of API calls that are cached"

2021-06-01 Thread darthmon_wmde 
darthmon_wmde closed this task as "Resolved".

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

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

To: Silvan_WMDE, darthmon_wmde
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, 
Nandana, 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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-14 Thread darthmon_wmde 
darthmon_wmde assigned this task to Silvan_WMDE.

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

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

To: Silvan_WMDE, darthmon_wmde
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, 
Nandana, 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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-11 Thread Maintenance_bot 
Maintenance_bot removed a project: Patch-For-Review.

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

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

To: Maintenance_bot
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, 
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331, Lalamarie69, Alter-paule, 
Beast1978, Un1tY, Hook696, Kent7301, joker88john, CucyNoiD, Gaboe420, 
Giuliamocci, Cpaulf30, Af420, Bsandipan, Lewizho99, Maathavan
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T274413: Retrieve metric "% of API calls that are cached"

2021-05-11 Thread gerritbot 
gerritbot added a comment.


  Change 686383 **merged** by Mforns:
  
  [analytics/refinery@master] oozie: Add oozie job for gather wikidata 
reliability metrics
  
  https://gerrit.wikimedia.org/r/686383

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

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

To: gerritbot
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, 
CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, 
_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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-11 Thread gerritbot 
gerritbot added a comment.


  Change 686066 **merged** by jenkins-bot:
  
  [analytics/refinery/source@master] Add scala job for reliability metrics of 
Wikidata
  
  https://gerrit.wikimedia.org/r/686066

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

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

To: gerritbot
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, 
CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Manuel, Lewizho99, 
Maathavan, _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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-07 Thread gerritbot 
gerritbot added a comment.


  Change 686383 had a related patch set uploaded (by Ladsgroup; author: 
Ladsgroup):
  
  [analytics/refinery@master] oozie: Add oozie job for gather wikidata 
reliability metrics
  
  https://gerrit.wikimedia.org/r/686383

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

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

To: gerritbot
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, 
CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Manuel, Lewizho99, 
Maathavan, _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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-06 Thread gerritbot 
gerritbot added a project: Patch-For-Review.

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

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

To: gerritbot
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, 
CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Manuel, Lewizho99, 
Maathavan, _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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-06 Thread gerritbot 
gerritbot added a comment.


  Change 686066 had a related patch set uploaded (by Ladsgroup; author: 
Ladsgroup):
  
  [analytics/refinery/source@master] Add scala job for reliability metrics of 
Wikidata
  
  https://gerrit.wikimedia.org/r/686066

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

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

To: gerritbot
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, 
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Manuel, _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] T274413: Retrieve metric "% of API calls that are cached"

2021-05-06 Thread Silvan_WMDE 
Silvan_WMDE added a comment.


  The cache hit ratio for API requests can be queried together with those for 
the entity pages (T274414 ) and the 
WDQS requests (T274415 ) by defining 
three separate "categories" like this:
  
SELECT
 COUNT(*) as count,
 CASE WHEN is_pageview = 1 THEN 'entity_page'
 ELSE
  CASE WHEN uri_path LIKE '/w/api.php%' THEN 'api'
  ELSE CASE WHEN uri_host = 'query.wikidata.org' AND uri_path LIKE 
'%/sparql' THEN 'wdqs'
   ELSE 'other'
   END
  END
 END AS request_category,
 CASE WHEN cache_status IN ('pass','miss') THEN 0 ELSE 1 END AS is_cached
FROM
  wmf.webrequest
WHERE
  uri_host IN ('www.wikidata.org', 'query.wikidata.org')
  AND (is_pageview = TRUE OR uri_path LIKE '/w/api.php%' OR uri_path LIKE 
'%/sparql')
  AND year = 2021
  AND month = 5
  AND day = 6
  AND hour = 8
GROUP BY
 (CASE WHEN is_pageview = 1 THEN 'entity_page'
 ELSE
  CASE WHEN uri_path LIKE '/w/api.php%' THEN 'api'
  ELSE CASE WHEN uri_host = 'query.wikidata.org' AND uri_path LIKE 
'%/sparql' THEN 'wdqs'
   ELSE 'other'
   END
  END
 END),
  (CASE WHEN cache_status IN ('pass','miss') THEN 0 ELSE 1 END)
ORDER BY request_category, is_cached
LIMIT 25;

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

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

To: Silvan_WMDE
Cc: Silvan_WMDE, Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, 
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Manuel, _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] T274413: Retrieve metric "% of API calls that are cached"

2021-04-20 Thread darthmon_wmde 
darthmon_wmde updated the task description.

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

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

To: darthmon_wmde
Cc: Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T274413: Retrieve metric "% of API calls that are cached"

2021-04-20 Thread Lydia_Pintscher 
Lydia_Pintscher added a project: Wikidata.

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

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

To: Lydia_Pintscher
Cc: Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs