Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread Marco Schuster
Hi, when you click on World Clock => Fixed Time World Clock, you can enter a date/time combo. Given the start date of 06/12/2010 00:00:00 UTC, I'd prefer http://www.timeanddate.com/worldclock/fixedtime.html?day=6&month=12&year=2010&hour=0&min=0&sec=0&p1=0 to be linked in the email. This way an us

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread River Tarnell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marco Schuster: > please use a service like http://www.timeanddate.com/worldclock/ in > the future when specifying dates/times. Sorry, I don't understand what you're asking for here. Can you give an example? - river. -BEGIN PGP SIGNATUR

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread Marco Schuster
Hi River, please use a service like http://www.timeanddate.com/worldclock/ in the future when specifying dates/times. This way you can use the 12h format you're used to, but the non-English people who use the 24h format or do not live in European time zones can exactly see when the maintenance aff

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread River Tarnell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Aryeh Gregor: > On Mon, Nov 29, 2010 at 11:27 AM, River Tarnell > wrote: > > Start time: Monday, 6th December, 12AM UTC > > End time: Monday, 6th December, 8AM UTC (estimated) > Are these reversed or what? No. 12AM (h) is before 8AM (0800h).

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread MZMcBride
Aryeh Gregor wrote: > On Mon, Nov 29, 2010 at 11:27 AM, River Tarnell > wrote: >> Start time: Monday, 6th December, 12AM UTC >> End time: Monday, 6th December, 8AM UTC (estimated) > > Are these reversed or what? I don't follow. A day starts at 12:00 AM and goes until 11:59 PM. River's post seems

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread Krinkle
Yeah, I thought the same at first but I had this confusion before. It goes like this for comparison to european / 24h times : 24 notation: 00:00, 08:00, 11:00, 12:00, 20:00, 23:00, 24:00 Are the same as these in that order: 12 AM, 8 AM, 11 AM, 12 PM, 8 PM, 11 PM, 12 AM -- Krinkle Op 30 nov 201

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread Kalan
On Tue, Nov 30, 2010 at 03:04, Aryeh Gregor wrote: >> Start time: Monday, 6th December, 12AM UTC >> End time: Monday, 6th December, 8AM UTC (estimated) > Are these reversed or what? They read 2010-12-06 00:00 and 2010-12-06 08:00 respectively, no reversing. 12-hour clock, and specifically its AM

Re: [Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread Aryeh Gregor
On Mon, Nov 29, 2010 at 11:27 AM, River Tarnell wrote: > Start time: Monday, 6th December, 12AM UTC > End time: Monday, 6th December, 8AM UTC (estimated) Are these reversed or what? ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread Михајло Анђелковић
Hm, that is very correct. The data I've got do not have this info. But I won't run such a query again soon, since this still does the job: for now I only want to acknowledge when somebody has left sr.wp and to book the reason by reviewing the talk and other relevant pages from that time. Thank yo

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread River Tarnell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Михајло Анђелковић: > Namespaces are easily determined from the page prefix, I am not > bothered if there are any anomalies out there (i.e. page starting with > "User talk:" being in NS 0) There are no page namespace prefixes in the databases. IOW, "

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread Михајло Анђелковић
Thank you, guys, I've already taken what I needed. Namespaces are easily determined from the page prefix, I am not bothered if there are any anomalies out there (i.e. page starting with "User talk:" being in NS 0) and the query is lighter in case ns isn't being pulled out from the DB. In overall,

Re: [Toolserver-l] Monthly pageviews

2010-11-29 Thread MZMcBride
Krinkle wrote: > Op 15 nov 2010, om 19:22 heeft Magnus Manske het volgende geschreven: > >> I know there are lots'o'files for daily (hourly?) pageview stats on >> the toolserver. > > Where are these text files actually ? /mnt/user-store/stats/ MZMcBride _

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread MZMcBride
Михајло Анђелковић wrote: > I would ask for allowance to run a request that can be resource > consuming if not properly scaled: > > SELECT page.page_title as title, rev_user_text as user, rev_timestamp > as timestamp, rev_len as len FROM revision JOIN page ON page.page_id = > rev_page WHERE rev_id

[Toolserver-l] General maintenance notice: December 6th

2010-11-29 Thread River Tarnell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On the morning (UTC) of December 6th we will perform general maintenance[0] on all servers. Services will be affected as follows: Service | Expected impact -+---

Re: [Toolserver-l] Problem with matplolib / pylab

2010-11-29 Thread Robin Krahl
> This should be fixed now. Thank you! Regards, Robin ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailin

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread Platonides
Михајло Анђелковић wrote: > Hello, > > I would ask for allowance to run a request that can be resource > consuming if not properly scaled: > > SELECT page.page_title as title, rev_user_text as user, rev_timestamp > as timestamp, rev_len as len FROM revision JOIN page ON page.page_id = > rev_page

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread River Tarnell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Михајло Анђелковић: > WHERE rev_id > 0 AND rev_id < [...] AND rev_deleted = 0; Please check that MySQL plans this correctly (using the rev_id index). > If this is generally allowed to do, my question is how large chunks of > data can I take at once,

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread Михајло Анђелковић
Unfortunately, the complete dumps contain lots if data I don't actually need and I am afraid I am not willing to commit such an impact to my small HDD. And even more, they are really unavailable since 10.11, which is kind of very long already. Right now I have time for this research and I want to

Re: [Toolserver-l] Extracting basic revision data

2010-11-29 Thread Petr Kadlec
2010/11/29 Михајло Анђелковић : > This is intended to extract basic data about all publicly visible > revisions from 1 to [...]. Info about each revision would be a 4-tuple > title/user name/time/length. I need this data to start generating a > timeline of editing of srwiki, so it is intended to be