[00:06:40] Urbanecm: well... that cluster is the one that is designated for heavy queries. There may be nasty things running there right now that are competing with you [00:08:00] bd808, I understand the analytics cluster is designed for heavy queries, and that queries might run for a longer time on that cluster, but I don't think the queries should be running 5000 times slowed than on web cluster - that's why I left a message here [02:29:48] !log tools.admin Restarted webservice [02:29:50] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.admin/SAL [02:41:08] Urbanecm: https://tools.wmflabs.org/sql-optimizer?use=cswiki_p&sql=SELECT%0D%0A++page_title%0D%0AFROM%0D%0A++revision%0D%0A++JOIN+page+ON+page_id+%3D+rev_page%0D%0AWHERE%0D%0A++rev_user_text+%3D+%22Martin+Urbanec%22%0D%0A++AND+rev_parent_id+%3D+0%0D%0AORDER+BY%0D%0A++rev_timestamp+DESC%0D%0ALIMIT%0D%0A++10%3B [02:43:17] using revision_userindex shortenes it to 2.40 sec [02:45:11] though yes that is still 100x slower than web cluster running the original query [15:09:42] Hi, what you think about adding Portal namespace at wikitech.wikimedia.org_ [15:10:01] Because there we already use it but it`s in main namespace instead of Portal namespace [15:10:08] Example https://wikitech.wikimedia.org/wiki/Portal:Cloud_VPS/instance_lifecycle [22:01:59] I will let you know when I see Zoranzoki21 and I will deliver that message to them [22:01:59] @notify Zoranzoki21 https://phabricator.wikimedia.org/T123427 -- discussed before, not sure if anything has changed to make it worth the config change for the 4 pages in https://wikitech.wikimedia.org/wiki/Category:Portals [22:03:46] !log admin Set floatingip quota of 60 for tools project in eqiad1-r region (T212360) [22:03:49] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [22:03:49] T212360: Create hostnames for old and new Toolforge bastions that make sense - https://phabricator.wikimedia.org/T212360 [22:06:46] !log tools Added floating ip to tools-sgebastion-06 (T212360) [22:06:50] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [22:43:43] Are there tools that use Ruby on Rails, and if so, do they configure _test databases? [22:44:25] !help Are there tools that use Ruby on Rails, and if so, do they configure *_test databases? [22:44:26] audiodude: If you don't get a response in 15-30 minutes, please create a phabricator task -- https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?projects=wmcs-team [22:46:28] I am not familiar with any. Sqlite might work, but otherwise I don't know that external CI would hit toolsdb [22:47:49] hmm, that's kind of a roundabout way of asking my real question which is how *I* can set up such a test database [22:48:24] but you're right I would have problems with Travis CI [22:49:09] the problem with sqlite is that it uses different syntax, so I can't test queries with say "ON DUPLICATE KEY UPDATE" directly [22:49:36] hrm...I'd have to give it more thought. I was a rails dev at one time, but I haven't tried using it in toolforge. [22:50:03] Yes. I usually tested on a real DB myself for that reason [22:50:55] Maybe make a task so we can poke it? Others may have information I don't, if nothing else [22:53:26] okay cool, I'll make a task and see if I can outsource some brainpower :) [22:53:33] And for reference, this isn't actually a Rails project [22:53:56] I just want to follow the Rails-like pattern of creating and tearing down a test database, possibly with fixtures, for my tests [23:14:17] Ahh ok. [23:19:15] https://phabricator.wikimedia.org/T213039