My conscious is a jukebox
I am in the process of getting prod db access and will get back to you. Rest assured I won't forget about this, though, we will get that table deleted when we are finished :) There a slew of types of queries I would like to test. I happen to know of some busy-ish ranges over the past month, too, so hopefully this go around we'll have some definitive answers on query performance.
Wed, Mar 22
@jcrespo Nice! It looks like SELECT HEX(INET6_ATON('192.168.0.1')); does exactly what we want, but it doesn't work on my local MySQL. If it works on the slave you created, I think you could do something like (I'm unable to test):
INSERT INTO ip_changes (ipc_rev_id, ipc_rev_timestamp, ipc_hex) SELECT rev_id, rev_timestamp, CONCAT(IF(LENGTH(rev_user_text) > 15, 'v6-', ''), HEX(INET6_ATON(rev_user_text))) AS ipc_hex FROM revision WHERE rev_timestamp > '20170222000000' AND rev_user = 0;
That will give you all IP edits over the last month. The hex for IPv6 is prefixed with v6-
@jcrespo Finally got around to this, below are my results. This test query was ran on my local Vagrant, where there are maybe 1,000 or so revisions. I'm hoping this is enough for you to do your analysis.
Tue, Mar 21
I think all the data is there now, check out http://localhost:8000/articleinfo/en.wikipedia.org/Bonzun (this one has checkwiki errors at the time of writing)
Mon, Mar 20
@Nuria Works great, thank you! :)
Fri, Mar 17
Not sure why the bot didn't comment: https://gerrit.wikimedia.org/r/#/c/343332/
Thu, Mar 16
2 GB of RAM? Are we sure we need that much?
So for March 14 we had this: https://wikimedia.org/api/rest_v1/metrics/pageviews/top/ru.wikipedia/all-access/2017/03/14
Wed, Mar 15
Tue, Mar 14
The code I worked on included a LOT of stuff outside articleinfo, so I kept merging into master so it can be used elsewhere and also to avoid edit conflicts. Hence I have no PR, but you can comment on this commit which touches all relevant files to articleinfo: https://github.com/x-tools/xtools-rebirth/commit/36621672301df077a471011cd298e144a049fcc3
All looks good to me, PR merged.
Mon, Mar 13
Sun, Mar 12
Done! As always thank you for your enormous help :)
Thanks! I was not aware of this trick. All links to a wiki page should now include lang and dir attributes, with exception of cross-language projects like Commons and Wikidata. As I said in the other ticket, I've also deployed tons of other RTL fixes too, mostly CSS.
Wow... I've only just now figured out that I needed to source CLDRPluralRuleParser.js!!! I had no idea! I assumed I should use everything in https://github.com/wikimedia/jquery.i18n/tree/master/src and nothing more. This fixes both issue 125 and 105. Goodness... I just can't believe I've gone this long with PLURAL not working for many languages. Sorry I didn't figure this out sooner. I will make a pull request to improve the jquery.i18n README, and explicitly list what needs to be sourced.
Fri, Mar 10
Sorry, let me make sure I've got this right: The cookie expires after 30 days, and localStorage after 1 day, correct? I tested this on CommTechWiki and it seems that the cookie is now being set to expire after 24 hours.