[02:06:04] <SigmaWP>	 https://pastebin.com/V30v8L6s is there any reason why this query is extremely slow?
[02:41:01] <SigmaWP>	 13 minutes to basically run grep over 196000 rows seems kind of excessive
[02:59:15] * ToBeFree , a SQL newbie, has once heard something about JOINs being potentially extremely slow and memory-hungry
[03:00:34] <ToBeFree>	 I think the reason given was that even if the resulting table is small, the process of getting that small table may involve a lot of work
[03:01:19] <ToBeFree>	 on the other hand, you seem to be proficient and I'm not, so you're likely not having an issue that I can debug
[03:34:37] <SigmaWP>	 https://pastebin.com/Quzp4v1N
[03:34:48] <SigmaWP>	 this one is basically, "get all the edits the person has made"
[03:34:52] <SigmaWP>	 and it takes 27 MINUTES
[03:45:48] <SigmaWP>	 ToBeFree: i thought revision has an index on revision IDs though so it shouldn't be bad
[03:45:53] <SigmaWP>	 but i don't know about efficiency in sql
[03:46:01] <SigmaWP>	 i mostly  just know how to get the stuff i want
[03:46:55] <ToBeFree>	 they told me subqueries can solve such performance problems, if it is the type of performance problem they had been talking about ^.^
[05:02:34] <JJMC89[m]>	 SigmaWP: I'm a little late but see https://phabricator.wikimedia.org/T224850
[05:04:59] <SigmaWP>	 JJMC89[m]: hm, looks about right
[05:06:04] <SigmaWP>	 JJMC89[m]: i'm confused by the bottom of the thread, has anything been deployed yet or no?
[05:15:57] <JJMC89[m]>	 Let me check
[05:18:59] <JJMC89[m]>	 SigmaWP: Looks deployed to me.
[05:19:50] <JJMC89[m]>	 https://wikitech.wikimedia.org/wiki/News/Actor_storage_changes_on_the_Wiki_Replicas#The_actor_table_seems_really_slow--so_does_comment lists the new views.
[05:20:28] <SigmaWP>	 oh, cool
[05:23:56] <Tulsi>	 Is there Wikitech admins available?
[05:23:57] <Tulsi>	 https://toolsadmin.wikimedia.org/tools/membership/
[05:24:58] <Tulsi>	 Someone please approve current membership requests, MediaWiki Training 2019 has started 
[05:25:29] <Tulsi>	 https://meta.wikimedia.org/wiki/CIS-A2K/Events/MediaWiki_Training/2019
[05:26:18] <JJMC89[m]>	 Tulsi: Given the day and time it is unlikely, but your can try asking in #wikimedia-cloud.
[05:29:33] <SigmaWP>	 JJMC89[m]: just to be sure, revision_userindex has an index on rev_actor, right?
[05:30:12] <SigmaWP>	 i'm just doing a simple `select COUNT(*) from revision_userindex where rev_actor=147498` and it's taking a long time...
[05:31:11] <SigmaWP>	 1 row in set (1 min 2.69 sec)
[05:33:36] <SigmaWP>	 MariaDB [enwiki_p]> show index from revision_userindex;
[05:33:36] <SigmaWP>	 Empty set (0.00 sec)
[05:33:38] <SigmaWP>	 ???
[05:34:36] <JJMC89[m]>	 https://phabricator.wikimedia.org/T221339 is about that, which is resolved
[05:36:16] <SigmaWP>	 but why is the query so slow
[05:36:57] <JJMC89[m]>	 It might be because of the temp tables being used in the view.
[05:39:10] <JJMC89[m]>	 I'm not a sql expert or an expert on the views. bstorm_ or anomie might be able to help when they're around.
[05:41:24] <SigmaWP>	 hmm
[07:36:31] <RF1dle>	 Anyone able to tell why the link doesn't form properly on https://quirc.miraheze.org/wiki/User:RhinosF1/sandbox
[07:51:05] <RF1dle>	 !help see above if this works in here
[07:51:05] <snitch>	 !(stalk|ignore|unstalk|unignore|list|join|part|quit)
[08:19:08] <amz3>	 Hello, I tried to create a page at https://meta.wikimedia.org/wiki/Grants:Project/WDQS_On_FoundationDB using the form but the page doesn't show up
[08:22:22] <RF1dle>	 Amz3: What's your username
[08:22:51] <amz3>	 RF1dle: Iamamz3
[08:24:15] <RF1dle>	 Amz3: Can You link me to your userpage?
[08:24:37] <amz3>	 RF1dle: https://meta.wikimedia.org/wiki/User:Iamamz3
[08:29:45] <RF1dle>	 Amz3: It's not saved or listed anywhere I can see as blocked. Did you get an error? Did you press save? And see the page was saved message?
[09:36:56] <amz3>	 RF1dle: nevermind, I will retry later.
[12:41:12] <jeblad>	 James_F:  Didn't want to spell it out, but in T223793#5245571 one user uses old wikieditor and I suspects he is visually impaired. He use VE to harvest citations, otherwise he use the old wikieditor. The new behavior gets in his way all the time, but I guess it is the same for a lot of users.
[12:41:13] <stashbot>	 T223793: On non-SET wikis (two edit tabs), links to new pages (red links) should open the user's preferred editor (last used) - https://phabricator.wikimedia.org/T223793
[12:42:01] <jeblad>	 The user is one of the largest contributors at nowiki.
[12:44:00] <jeblad>	 James_F: You are perhaps not Jdforrester?
[12:44:50] <jeblad>	 Also esanders and metamarex, they are also involved in  the change.
[12:44:53] <apergos>	 note it's rare for people to be around on a Sunday, at least not without a lot of latency
[12:45:01] <apergos>	 (also keep timezones in mind)
[12:46:03] <AntiComposite>	 They are on IRCCloud, so it is likely that they will get your message eventually
[12:47:55] <jeblad>	 Thanks.
[13:14:31] <ToBeFree>	 AntiComposite: 10 minutes later my IRCCloud connection died
[18:07:47] <snitch>	 [[Tech]]; L2212; /* Changing the sidebar "In other projects" links */; https://meta.wikimedia.org/w/index.php?diff=19145075&oldid=19142866&rcid=13696669
[20:08:59] <amz3>	 I retried to create my proposal with using "Start your application" box at https://meta.wikimedia.org/wiki/Grants:Project/Apply
[20:09:05] <amz3>	 it failed again.
[20:09:32] <RF1dle>	 Amz3: any errors?
[20:09:37] <amz3>	 no
[20:09:48] <RF1dle>	 Amz3: one sec
[20:09:51] <amz3>	 I saw a popup telling me to improve my application, that is all.
[20:10:10] <RF1dle>	 Amz3: Take a screenshot
[20:10:44] <amz3>	 https://meta.wikimedia.org/wiki/Grants:Project/Apply
[20:10:46] <amz3>	 ooops
[20:11:28] <amz3>	 https://meta.wikimedia.org/wiki/Grants:Project/WDQS_On_FoundationDB
[20:11:41] <amz3>	 same url as before. Maybe it is an anti-spam?
[20:12:01] <amz3>	 since my account page is empty: https://meta.wikimedia.org/wiki/User:Iamamz3
[20:12:34] <RF1dle>	 Amz3: Screenshot it - I can't see abuse filters triggered
[20:16:10] <amz3>	 I have the screenshot
[20:21:24] <amz3>	 RF1dle: What should I do with the screeshot?
[20:21:35] <RF1dle>	 amz3: post it here
[20:22:51] <amz3>	 https://i.imgur.com/jexq8Al.png
[20:25:07] <RF1dle>	 amz3: For your grant not userpage
[20:26:22] <amz3>	 https://i.imgur.com/HSLJYWz.png
[20:26:26] <amz3>	 sorry noob mistak
[20:27:36] <RF1dle>	 amz3: When you are warned about it not being right
[20:28:26] <amz3>	 Like I said, there is no error. It just display that page, with popup saying 'continue to good work' but the page is empty.
[20:28:45] <amz3>	 I will retry
[20:29:09] <RF1dle>	 amz3: Shall I try to create the page for you?
[20:29:17] <amz3>	 I will do it
[20:30:00] <RF1dle>	 okay amz3, let me know if you need me to create it manually so you can edit from there once it's created
[20:30:42] <amz3>	 RF1dle: you know, I think I have a clue what happened
[20:30:50] <RF1dle>	 amz3: what?
[20:31:49] <amz3>	 RF1dle: the first time I try to create the page, I hit the BLUE button bellow the pink button first, then I hit back, and hit the pink button
[20:32:00] <RF1dle>	 amz3: ah
[20:32:08] <amz3>	 I just try to create a porposal filled with "tests" it worked.
[20:32:31] <amz3>	 that might be something
[20:33:19] <RF1dle>	 amz3: good
[20:34:30] <amz3>	 what should i do then?
[20:34:46] <amz3>	 hit the blue box and continue from there?
[20:35:06] <amz3>	 or renmae my "test" page into the real page? 
[20:35:25] <amz3>	 or something else?
[20:35:34] <RF1dle>	 amz3: just rename the test one, I might have to move for you fi there's no option
[20:35:41] <amz3>	 tx
[20:36:30] <RF1dle>	 amz3: Can you move it or shall I?
[20:36:52] <amz3>	 RF1dle: I can NOT rename
[20:37:05] <RF1dle>	 amz3: I'll do it now
[20:37:06] <amz3>	 RF1dle: yes please, WDQS_On_FoundationDB is the nae
[20:38:16] <amz3>	 tx!
[20:40:21] <RF1dle>	 amz3: DONE
[20:40:32] <amz3>	 :)
[20:40:34] <RF1dle>	 https://meta.wikimedia.org/wiki/Grants:Project/WDQS_On_FoundationDB
[21:25:11] <amz3>	 tx