Apologies if my request caused confusion as to what I actually want. I'll try to explain.

Right now, I have several GLAM tools on the toolserver that deal with (detailed and aggregated) view counts. They get their data from stats.grok.se, some via PHP/shell, others via JavaScript/JSONP.

I have an account with tools labs, and have ported several tools there already [1]. I really want to port the GLAM tools as well, but I see little point in doing so as long as stats.grok.se remains a bottleneck.

So, a 1:1 "mirror" of stats.grok.se would work for me; however, I think this can be done more efficient and resource-saving.
Thus, /ideally/, I would like a read-only MySQL database, accessible on tools labs, that has data on how often every page, in every project, was viewed on each day. Monthly view counts would be OK as well, hourly would be fine but too detailed for my purposes (though other people might want that eventually).

Therefore, my thought was that /if/ this data already exists as a database on the labs infrastructure (which I understood is the case), would it be possible to expose that part of it, similar to the way a part of the wiki(p|m)edia projects are exposed (e.g. user data is filtered out).

So I don't need some giant machine to run scripts on; tools labs will do just fine for my purposes. The database is what I'm after ;-)

Thanks,
Magnus

[1] tools.wmflabs.org/magnustools



On Sun, Jun 16, 2013 at 2:18 PM, Diederik van Liere <dvanliere@wikimedia.org> wrote:
Well nemo don't jump to conclusions too soon.
D
—
Sent from Mailbox for iPhone


On Sun, Jun 16, 2013 at 8:38 AM, Federico Leva (Nemo) <nemowiki@gmail.com> wrote:

Diederik van Liere, 16/06/2013 14:30:
> I think we can do with less hardware; initially we can keep only the data for the last 3 months and I don't think it needs 12gb for a simple webapp

Well, that's what Henrik uses on his own. I hope the WMF can offer a
machine which doesn't have less performance than a 3 years old server
offered by a volunteer on his own.

Nemo



_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics