[03:44:55] <MusikAnimal>	 hello, when querying the revision_userindex table, is querying by `rev_id` (user ID) any faster than `rev_user_text` (username)?
[03:46:42] <Krenair>	 MusikAnimal, `rev_id` (user ID) ?
[03:46:49] <Krenair>	 you mean rev_user (user ID) ?
[03:47:00] <MusikAnimal>	 oops, yes rev_user
[03:47:12] <Krenair>	 you probably should not be querying against rev_user_text directly
[03:47:16] <Krenair>	 it's not always up to date
[03:47:26] <MusikAnimal>	 really
[03:47:38] <Krenair>	 yep, it's been missed in older renames
[03:47:47] <MusikAnimal>	 right, because that info actually lives in another table
[03:47:54] <Krenair>	 sometimes you'll find multiple distinct rev_user_text values for the same rev_user
[03:48:04] <MusikAnimal>	 oh dear
[03:48:07] <Krenair>	 obviously you'll need to look at rev_user_text for IPs
[03:49:10] <MusikAnimal>	 well, let's assume there are no such implications. Is `rev_users` still going to be faster? e.g. is that the column that is indexed?
[03:49:20] <MusikAnimal>	 `rev_user`
[03:50:02] <d3r1ck>	 hey people :)
[03:51:21] <MusikAnimal>	 just trying to work on some performance improvements with my tools. It's not clear what the indexed columns are from the docs, and with the query caching it's hard to say if using rev_user is faster
[07:43:22] <thedj_>	 Volker_E: I hope this makes it understandable. I also made tickets
[08:21:38] <TheAmishAreDumb>	 Lol
[08:22:19] <TheAmishAreDumb>	 !ops Anyone mind if I make a few unsourced edits to the Amish article?
[08:22:49] <TheAmishAreDumb>	 !ops The Amish eat 10 pounds a piece of dog shit a day
[08:22:59] <TheAmishAreDumb>	 !ops I like abusing the !ops trigger
[09:54:26] <Nemo_bis>	 How nice https://protonmaildotcom.wordpress.com/2015/11/05/protonmail-statement-about-the-ddos-attack/
[13:01:25] <millosh>	 hey, may somebody check this: https://meta.wikimedia.org/w/index.php?title=User_talk%3AMillosh&type=revision&diff=14493751&oldid=14279588
[13:01:37] <millosh>	 there is standard sign at the end
[13:01:51] <millosh>	 however, it turns out that the guy has signed as myself
[13:01:54] <millosh>	 known bug?
[13:02:11] <millosh>	 oh, i know
[13:02:12] <millosh>	 forget
[13:02:18] <millosh>	 <nowiki> tag previously
[17:11:04] <snitch>	 [[Tech]]; Dgfgjfj; /* THIS @@ {[{[{ 1 844 231 5378 }]}]** HOTMAIL customer care phone number ** HOTMAIL customer service phone number ***** */ new section; https://meta.wikimedia.org/w/index.php?diff=14501716&oldid=14477733&rcid=6976969
[17:12:15] <snitch>	 [[Tech]]; Tegel; Reverted changes by [[Special:Contributions/Dgfgjfj|Dgfgjfj]] ([[User talk:Dgfgjfj|talk]]) to last version by ArchiverBot; https://meta.wikimedia.org/w/index.php?diff=14501736&oldid=14501716&rcid=6976973
[17:41:16] <Nemo_bis>	 Missing system message for log entry? https://www.mediawiki.org/wiki/Special:Log/Tropicalkitty
[17:41:23] <Nemo_bis>	 "<logentry-lock-flow-lock-topic> (marked as resolved)"
[17:43:04] <Krenair>	 RoanKattouw_away, ^
[18:09:48] <RoanKattouw>	 Krenair: Whoa wtf
[18:10:15] <RoanKattouw>	 I don't know how to fix that immediately, so I'll file a bug
[18:10:32] <Reedy>	 Add the message? :P
[18:11:05] <RoanKattouw>	 It didn't exist in the previous branch either
[18:11:12] <RoanKattouw>	 Also why is there a Flow log entry for an article page...
[18:11:21] <RoanKattouw>	 Oh nm it's by user
[18:13:23] <RoanKattouw>	 https://phabricator.wikimedia.org/T118002