My username is rbaasland and I would like to contribute to the analytics
project. I was wondering if I could have access to the project, or how I go
about contributing to this project?
Thank you very much,
My name is Neta Livneh and I'm a FOSS OPW Intern, working with the language
engineering team on estimating how many translated pages there are in
For my project, we will need to sql queries on current wikipedia data
(mostly revision history table).
I already have a Gerrit account. Can I get SSH access for running such
Please join the Analytics Engineering team for...
Office Hours: EventLogging & Dashboarding
Hosts: Dan and Nuria
Date: January 14
Time: 20:00 UTC - Convert to Local Time
Teams need metrics on how their product or feature is performing, then they
need to visualize those metrics. This is accomplished with instrumenting
code with EventLogging, mashing data with some queries and setting up a
Limn Dashboard. The Analytics Engineering team is open for office hours to
answer questions about the process, help solve any issues and listen to
feedback on the process. Feel free to drop in the Goolge Hangout linked
above or ask questions on the IRC channel during our Office Hours.
just a quick heads up, that Ops are about to add a “php” key to the
X-Analytics header (i.e.: for sampled-1000 logs, hive, ...):
This header will hold the used PHP implementation .
Planned deployment is between 2014-09-01 and 2014-09-02.
---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ----
Companies' registry: 360296y in Linz
Kefermarkterstrasze 6a/3 Email: christian(a)quelltextlich.at
4293 Gutau, Austria Phone: +43 7946 / 20 5 81
Fax: +43 7946 / 20 5 81
This is not urgetn, but if anyone is interested in troubleshooting a
(probably basic) problem I am having with mysql, I would appreciate it!
I am trying to query the MobileWebClickTracking table, which is ginormous
and keeps timing out or boiling my RAM So Dario suggested I use screen to
dump a section of the table into a more workable table.
Here is his test query that seemed to work:
*screen mysql -h analytics-store.eqiad.wmnet -B -e "CREATE TABLE
staging.jkatz_foo SELECT * FROM enwiki.user LIMIT 300;"*
I tried to do this on my own (I use analytics-slave instead, as my
credentials don't seem to work on analytics-store), and it doesn't seem to
do anything. Can you try on your end and let me know if you're having any
Here is the query:
jkatz@bast1001:~$ mysql -h analytics-slave.eqiad.wmnet -u research
-pJoFjnA90Ajyp -B -e "Insert into staging.jkatz_clicktracking1 Select *
from log.MobileWebClickTracking_5929948 WHERE ('timestamp' between
20141101000000 and 20141130000000) and wiki like 'enwiki';"
When I look in processes in stat1003, I only see a sleep command--no query:
[image: Inline image 2]
Is the query within that sleep? Anyway, I seem to be creating tables but
they do not have any rows in them. I have double checked that the data
between those dates exists in that table.
I am working on adding performance instrumentation to Parsoid and I would
like to get some feedback on what frontend to use in visualizing the data.
It seems like general performance is visualized via Graphite (soon to be
Grafana?) at <https://gdash.wikimedia.org/>, while Visual Editor
performance is visualized via Limn. Are there any guidelines that would
determine which to use?
Also, @ Dan Andreescu : Thanks for the link to the SQL Queries, they were
exactly what I was looking for.
Would someone be able to explain the measurements used to calculate the
rates on the <https://edit-reportcard.wmflabs.org/> page? Are metrics, for
example 'save_rate_attempts', computed like: aggregate save_rate_attempts
/ 24 hrs?