You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org
ORES/Metrics: Difference between revisions
< ORES
Jump to navigation
Jump to search
imported>Amir Sarabadani (WMDE) No edit summary |
imported>Ladsgroup No edit summary |
||
Line 11: | Line 11: | ||
*[[Grafana.wikimedia.org/ores.json]] (obsolete: [https://github.com/wiki-ai/grafana-dashboards See the github repo]) | *[[Grafana.wikimedia.org/ores.json]] (obsolete: [https://github.com/wiki-ai/grafana-dashboards See the github repo]) | ||
== Views == | |||
The view data if they are behind varnish (meaning internal requests like change propagation or mediawiki request are not logged) can be found in [[Analytics/Data Lake/Traffic/Webrequest|Webrequest database]] in hadoop. | |||
For example this groups IPs and order them by hit count for September 4th, 2018: | |||
<pre> | |||
SELECT ip, count(*) as hitcount | |||
FROM wmf.webrequest | |||
WHERE | |||
uri_host = 'ores.wikimedia.org' AND | |||
year = 2018 AND | |||
month = '09' AND | |||
day = '04' | |||
GROUP BY ip | |||
ORDER BY hitcount DESC | |||
LIMIT 500; | |||
</pre> | |||
[[Category:ORES]] | [[Category:ORES]] |
Revision as of 19:46, 5 September 2018
Metrics are captured via a statsd endpoint. They can be found under ores at https://graphite.wikimedia.org. Graphs are curated at https://grafana.wikimedia.org/dashboard/db/ores
- Labs statsd
- labmon1001.eqiad.wmnet configured in https://github.com/wiki-ai/ores-wmflabs-deploy/blob/master/config/00-main.yaml
- Production statsd
- graphite-in.eqiad.wmnet configured in https://github.com/wikimedia/operations-puppet/blob/production/modules/ores/manifests/web.pp
- grafana-dashboard json backup
Views
The view data if they are behind varnish (meaning internal requests like change propagation or mediawiki request are not logged) can be found in Webrequest database in hadoop.
For example this groups IPs and order them by hit count for September 4th, 2018:
SELECT ip, count(*) as hitcount FROM wmf.webrequest WHERE uri_host = 'ores.wikimedia.org' AND year = 2018 AND month = '09' AND day = '04' GROUP BY ip ORDER BY hitcount DESC LIMIT 500;