[03:07:39] <raidex>	 I've noticed the pagecounts data set has stopped updating since last night. (https://dumps.wikimedia.org/other/pagecounts-all-sites/2015/2015-07/). I've been looking for outage info to no avail. Does anyone have info on this? Thanks
[03:28:05] <mutante>	 raidex: i checked the dumps server, it looks ok, but that server gets the pagecounts from another server, stat1002, and that is extremely busy and controlled by the analytics team which is running some scripts apparently. i reported in #wikimedia-analytics thought the time isn't the best for US timezone
[03:40:35] <MusikAnimal>	 hello, could someone tell me exactly what the "archive" table is in the database? enwiki_p specifically
[03:42:29] <Glaisher>	 MusikAnimal: deleted pages
[03:42:31] <Glaisher>	 well, not pages
[03:42:35] <Glaisher>	 but information about it
[03:42:48] <MusikAnimal>	 dah, of course
[03:42:50] <MusikAnimal>	 thank you
[03:42:56] <legoktm>	 MusikAnimal: hi! it's the equivalent of revision for deleted stuff
[03:43:11] <Glaisher>	 MusikAnimal: https://www.mediawiki.org/wiki/Manual:Archive_table
[03:43:15] <legoktm>	 MusikAnimal: https://www.mediawiki.org/wiki/Manual:Database_layout is very helpful
[03:43:41] <MusikAnimal>	 thank you legoktm!! I have been looking for this
[03:43:50] <MusikAnimal>	 Glaisher you as well
[03:44:10] <MusikAnimal>	 I'm trying to do some simple namespace edit counts, just to find out if it's any faster than the API
[03:44:25] <MusikAnimal>	 perhaps you already know the answer
[03:44:59] <legoktm>	 probably
[03:45:29] <Glaisher>	 What does the xtools editcount tool use? It seems fast.
[03:45:41] <MusikAnimal>	 I can't decipher the code haha
[03:46:26] <MusikAnimal>	 my guess is it uses revision_userindex and joins with page, but when I tried something like that it was not so fast