May 21 2019
My web tool is now fine, the performance is OK. Thank you! :-)
May 19 2019
Weird. Runs fast on SQL console but slow in a web-based tool.
Anyway, I see this is being taken care of. https://phabricator.wikimedia.org/T221339
The same query on the indexed rev_user_text field executed in 7 seconds, instead:
Still slow. The query executed in 21 minutes. revision_userindex has no index on rev_author either, indeed.
Sure! In my case, I'm trying to find the the IDs of all the pages edited by both User:Pietrodn and User:Frieda (the database is itwiki_p).
I tried to update one of my tools (intersect-contribs) to use the actor table instead of the revision.rev_user_text field.
Nov 24 2018
The patch to pywikibot has been merged, which resolved the problem for me: https://gerrit.wikimedia.org/r/#/c/pywikibot/core/+/167532/
Dec 16 2016
Thank you. The spam has stopped. :)
Oct 13 2016
Working workaround for Chrome and Safari on macOS Sierra: http://apple.stackexchange.com/a/257112/33925
More detailed explanation of the technical problem by GlobalCert:
GlobalSign suggested the following workaround, it's unclear whether it actually works or not: https://support.globalsign.com/customer/portal/articles/1353318-view-and-or-delete-crl-ocsp-cache