[02:25:02] [[Tech]]; Quiddity (WMF); /* Sorting in categories on cswiki */ pointer; https://meta.wikimedia.org/w/index.php?diff=16257308&oldid=16246482&rcid=8875267 [02:40:31] [[Tech]]; Quiddity (WMF); unsigned comments (since 2015!); https://meta.wikimedia.org/w/index.php?diff=16257314&oldid=16257308&rcid=8875279 [07:55:37] [[Tech]]; ArchiverBot; Bot: Archiving 1 thread (older than 30 days) to [[Tech/Archives/2016]].; https://meta.wikimedia.org/w/index.php?diff=16257564&oldid=16257314&rcid=8875599 [08:42:00] https://wikitech.wikimedia.org/wiki/Piwik [15:03:03] Big stuff https://phabricator.wikimedia.org/T156026 [16:00:04] Is it possible (in quarry) to only "use" the latest e.g. 1000 articles created, instead of the entire "USE enwiki_p;" which kills my queries, due to time and memory... [16:01:33] Nemo_bis, Steinsplitter: Anyone of you know? [16:01:59] link? [16:02:39] https://quarry.wmflabs.org/query/9108 [16:03:19] Or is it possible to only check articles in a specific category, instead of the entire enwiki? [16:03:35] you are doing a lot of Joins which is slowing stuff down, the /* SLOW_OK */ is redundant (old toolserver stuff) [16:03:51] yeah, just for my onw notes.. [16:03:53] you are not checking the whole db, just the selecting tables [16:04:40] I know it is very slow, hence why I'm aking if it is posible to "Lower" the pool of articles, which may help...like only check articles in "Cateogry:1998 births" or soemthing [16:04:47] limit* [16:05:28] or would it be just as slow for that? [16:06:03] well, you are doing a lot of JOINS. [16:06:16] i can try to run it on labs if you need the data only once. [16:06:55] well, we do have Spcial:LonelyPages which does find 5000 articles per month [16:07:15] but I know there are a whole bunch more, but it would kill the all servers to find... [16:07:51] I've already limited it down to 10, which will be killed [16:07:53] Josve05a: I think you have some impossible conditions in there [16:09:11] Nemo_bis: Impossible? I can do LIMIT 1 or 2 just fine, so it is a working query, just slow due to the joins... [16:14:48] Josve05a: cl_to can only be one thing, for instance, not 3 [16:16:14] Well it does seem to work, on a small scale [18:09:52] hello, I'm consistently getting 503 errors hitting the enwiki API. Is this happening for anyone else? [18:09:54] for instance https://en.wikipedia.org/w/api.php?action=query&titles=MediaWiki&format=json&maxlag=-1 [18:10:21] yes [18:10:26] not sure if it's just that overloaded or if something else is going on [18:10:48] when it does load, the maxlag is very low [18:10:49] there's been some, uh, degradation? but folks are looking into it [18:10:57] ok thanks :) [20:01:25] [[Tech]]; MBq; /* Status of UserMerge ? */ new section; https://meta.wikimedia.org/w/index.php?diff=16258985&oldid=16257564&rcid=8877822 [20:06:08] [[Tech]]; Ruslik0; /* Status of UserMerge ? */; https://meta.wikimedia.org/w/index.php?diff=16258986&oldid=16258985&rcid=8877831