[02:14:45] hello, I'm having a difficult time getting basic SQL queries to execute when connected to replication database. I will provide an example [02:15:09] I have the SQL: `use enwiki_p; select count(*) from revision where rev_user = "Username" and rev_comment like "%[[WP:TW|TW]]%";` [02:15:44] that should give me the twinkle revisions from User:Username. Seems like this would execute fairly fast but instead it hangs and never completes [02:16:07] is there anything obvious that I'm missing? [02:18:13] do you really want to count all the columns (*) or just an id ? i think that and the "like" comparison will slow it down [02:18:43] let me try using just id [02:18:54] Glaisher: I think we already did that? :D [02:20:21] mutante: I tried using `rev_id` instead of `*` for the count and it's still hanging. How would the edit counters do it? Surely a similar way, and they run very fast [02:20:37] For the record, the xTools source is impossible to decipher [02:21:21] MusikAnimal: i think they won't care about the "rev_comment like" though [02:21:39] MusikAnimal: how is it without that condition [02:22:05] also they may have indices added for that [02:22:25] xTools shows all the semi-automated edits, along with detailed editing history, and does it very quickly [02:23:18] MusikAnimal: maybe you can find the SQL in xTools source? [02:23:49] MusikAnimal: Can you try running an EXPLAIN on that? [02:24:33] I don't see a specific index on rev_comment, so that like is probably not the fastest thing ever ;-) [02:25:01] it's difficult to tell what queries xtools is actually running, it's all fragmented with variables and such [02:25:06] at least for a non-PHP guy like me [02:25:21] lemme pop it in the prod db, sec. [02:25:56] ugh, I actually have to step away from the computer. Going to leave my IRC open, be back in a bit. Thank you!! [02:26:21] Hmm, not as bad as I thought [02:27:46] Ah, herp derp [02:28:13] https://phabricator.wikimedia.org/P961 [02:28:24] 269983350 rows is a lot to look at :p [02:28:55] If it doesn't actually end up using `user_timestamp` to filter by rev_user first. [03:24:35] ostriches: what if you used an actual username and not "Username" (I don't know who that is)... so maybe MusikPuppet (70 edits) [03:25:06] I guess I'm just bad at SQL. The idea here is target a user and search their contributions, as opposed to all contributions and then filtering ones made by that user [07:08:15] Did something happen on the memcached servers around June 5? https://phabricator.wikimedia.org/T102199 [07:13:44] Well, this doesn't look too good https://ganglia.wikimedia.org/latest/?r=custom&cs=05%2F01%2F2015+00%3A00&ce=07%2F15%2F2015+00%3A00&c=Memcached+eqiad&h=&tab=m&vn=&hide-hf=false&m=mc_evictions&sh=1&z=small&hc=4&host_regex=&max_graphs=0&s=by+name [09:04:29] Hi [09:04:44] Anyone here want to do something low level to FORCE something at wikisource to behave [09:04:46] ? [09:05:00] https://en.wikisource.org/wiki/Page:Mrs_Beeton%27s_Book_of_Household_Management_%28Part_2%29.djvu/618 - links to the WRONG part [09:05:10] and seems to defy logcial explanation as to why [11:13:39] Answer: No. [11:58:02] Nemo_bis - hmm [11:58:09] I found a temporary workaround [11:58:14] in any event [12:21:54] legoktm: oh indeed :) [12:22:13] it wasn't linked to the phab ticket [15:20:40] Hi everyone. Does anyone know if jforrester (james forrester from WMF) has an IRC accont? [15:20:48] Huji: Hey. :-) [15:20:59] Oh James_F there you are! [15:21:10] I emailed you about this too, but I thought IRC would be faster [15:21:19] I see you have created a jquery i18n module [15:21:32] can that be used in gadgets in WP? [15:21:42] like as a dependency? [15:23:36] Huji: I moved it into core, but yes. [15:23:46] core? which core? [15:23:55] Huji: Into MediaWiki core, I mean, sorry. [15:23:59] oh [15:24:07] Huji: It was already on WP for all users via UniversalLanguageSelector. [15:24:28] Can you please take a look at this test wiki which is hosted on Labs? https://fawp.wmflabs.org/wiki/MediaWiki:Gadgets-definition [15:24:47] you see, I listed jquery.i18n as a dependency, but I get error messages about its nonexistance in the console [15:25:05] James_F: what am I doing wrong? [15:25:17] Huji: Hmm. Interesting. [15:25:43] Huji: I don't know; I would have expected it to work. [15:26:00] Oh, wait. [15:26:07] This hasn't been merged yet, I think? [15:26:40] Yeah, that'd be it. [15:26:49] Oh; well then I'd be grateful if you would just show me how to use it for now. [15:27:00] That'll save me a lot of time really James_F [15:27:34] fawp.wmflabs.org doesn't have the UniversalLanguageSelector extension installed. [15:27:45] If you add that extension, the dependency will be available. [15:36:34] James_F: is the jquery.i18n stuff ready to be merged? [15:38:37] James_F: working on it! [15:38:54] legoktm: Nikerabbit is looking at the ULS patch now. [15:39:09] oh awesome! [15:42:23] woot [15:42:29] legoktm: there is something spamming in storeToArray with "manifest_version" [15:42:45] Nikerabbit: what version of core? [15:43:12] if it's 1.25.1, there's a patch merged in REL1_25 for it, but not yet released [15:43:18] legoktm: just updating master [15:43:32] o.o [15:43:45] what extension is this? ULS? [15:44:11] legoktm: monobook, but it went away after updating [15:44:30] how old was your master? [15:46:50] couple of days [15:50:40] that's...weird [15:53:19] James_F: enabling ULS did it, as you advised [15:53:21] thanks! [15:53:58] Huji: Excellent. :-) [22:37:16] anyone a 'crat on testwiki? [22:37:24] or could be so kind to make me a crat [22:37:39] please add the bot flag to User:MusikBot [22:38:40] someone is [22:40:14] can a bureaucrat add the bureaucrat to other accounts? or does that require a steward [22:40:58] no, bureaucrats can grant bureaucrat [22:41:46] MusikAnimal: bureaucrats can add b'cats [22:41:56] (such a long word) [22:42:04] *crats [22:42:17] well it'd be very kind if they could do that for me! :) [22:43:22] I'm an admin with nearly 1400 test edits [22:43:58] I do see that [22:44:03] Nice to meet you! [22:44:09] I am knowledgeable with testwiki inclusion criteria, and if you take a look for yourself, you'll see I have some fine pages that are my own work [22:44:16] no FAs or GAs, but still pretty good :) [22:44:30] I'm not a bureaucrat :) [22:44:37] I can ping a few... [22:44:44] overall, I think I'm an adept tester and could serve the community as a testwiki crat so that I can do more testing :) [22:44:45] hehe [22:45:34] most definitely. trust isn't the problem if your sysop on enwiki :) [22:45:40] haha I know [22:45:43] *you're [22:45:46] I'm just joking around [22:46:04] obviously not much for policy over at testwiki, just about testing [22:46:29] Krinkle: around for ^? [22:47:43] they have the "Wikipedians by number of edits" on enwiki, I wonder where I stand on testwiki [22:52:23] or legoktm ^ [22:52:49] I PMed legoktm, there's no rush [22:54:01] just messing around with the mediawiki gateway Ruby library and adding the bot flag, which is of course failing because of the assertion [23:04:52] in fact while they [23:05:03] 're at it they can also add me [23:05:20] * Negative24 is great at hitting the enter key rather than the shift key