[02:36:30] [[Tech]]; 91.193.178.42; /* Butun istifadecilere salamlar olsun. MOREgroup23 nedir? biz zamanla birnece sektorun istifaceisi, idarecisi ve qurucusu olaraq kicik bir sirket haline gelmis grupuz. */ new section; https://meta.wikimedia.org/w/index.php?diff=22483867&oldid=22475665&rcid=20975117 [02:39:55] [[Tech]]; Perryprog; Reverted 1 edit by [[Special:Contributions/91.193.178.42|91.193.178.42]] ([[User talk:91.193.178.42|talk]]) (TwinkleGlobal); https://meta.wikimedia.org/w/index.php?diff=22483873&oldid=22483867&rcid=20975129 [14:06:39] hi, is anyone around who could have a look at https://phabricator.wikimedia.org/T298225 and help judge the severity? [14:08:45] it’s my fault but it will be about 2 more hours before I can look into it [16:10:06] A query with 9 joins, a subselect, and an order clause... ouch [16:22:29] bd808: it sounds like that's Amir's work to block slow queries [16:22:33] Commented https://phabricator.wikimedia.org/T298225#7587643 [16:25:17] yeah, somebody needs to do an explain on it and figure out how many indices need to be added to make it not slow, if that's even possible [16:26:52] I'm pretty sure MediaWiki could use a full time sql optimizer as a contributor. Amir has been doing a lot of good work there, but he's also got a large value of N other interests [16:28:12] I'm sure there's a lot that could be done [16:31:20] definitely. Amir's kind enough to help with that as a Staff Database Architect [17:35:27] There's the little problem that typically the only performance consideration is "will it crash WMF production"? [17:45:06] if your site is big enough that some change tags will crash it… i hope you have a dba [17:46:53] it's a problem for WMF because we've had 450,000 tags inserted over a week [17:47:27] probably won't crash anyone else's unless you have numbers this large [19:57:18] hi all - not sure if this is the right channel for this, but I will mention it .. as an occassional user of Wikimedia image files, I clicked on a large jpg today [19:57:31] I went to cURL on the bash command line, and the same disconnect happened.. at the same spot? but the auto-reconnect feature kicked in [19:57:43] then a second disconnect, during download, at an equal interval later.. its completnig here now... but it smells like some misconfiguration, at a distance [19:58:32] http://paste.debian.net/1224578/ [19:59:16] Does it work fine in a browser (rather than curl)? [19:59:35] darkblueb: Hmm, i tried the wget from your pastebin and i didn't get any disconnect. Maybe something with your local network [19:59:39] no - FIrefox/Ubuntu failed, three times straight [20:00:10] the download from the browser failed in a simple, repeatable way.. thats why I bother to mention it here [20:00:25] Yeah.. It could be your local network, or your ISPs network too [20:00:33] ok, I can try a 60MB download from a server I control now [20:00:38] Hence just seeing if it was broken via other methods [20:01:07] that would be located at the Oregon State University Open Source Labs .. trying [20:02:21] Could be some sort of middlebox somewhere maybe [20:02:40] (oh hello Oregonian) [20:02:46] https://wikitech-static.wikimedia.org/wiki/Reporting_a_connectivity_issue [20:02:57] ^ might be useful for being able to file a task [20:07:19] darkblueb: maybe an outgoing proxy/network hardware is trying to enforce https://policy.oregonstate.edu/UPSM/08-005_acceptable_use_computing_resources and thinks it is "file sharing" or something [20:07:25] 160MB file from my a different source, just passed the mark [20:07:52] would report it to the lab too [20:08:16] mutante: good thinking but, the source of the error is OFF the lab equipment, ON the us-en-mediawiki [20:08:26] it is the OSUOSL server that works fine [20:08:33] oh, ok [20:09:20] my example is .. this same browser now, fails on the 60MG jpg shown, from us-en-mediawiki, and succeeds from OSUOSL server box [20:09:46] Reedy - does your nick mean "Reed College" ? [20:12:09] https://wikitech-static.wikimedia.org/wiki/Reporting_a_connectivity_issue OK so file a phabricator ticket it says [20:12:21] is that current advice? [20:29:01] yes, that page is up to date [20:29:36] ok thx [21:04:33] darkblueb: no it doesn't