My web tool is now fine, the performance is OK. Thank you! :-)

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).

Hi,
I tried to update one of my tools (intersect-contribs) to use the actor table instead of the revision.rev_user_text field.

The patch to pywikibot has been merged, which resolved the problem for me: https://gerrit.wikimedia.org/r/#/c/pywikibot/core/+/167532/

Thank you. The spam has stopped. :)

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:
https://downloads.globalsign.com/acton/fs/blocks/showLandingPage/a/2674/p/p-008f/t/page/fm/0

In T148045#2713539, @Zppix wrote:

@Pietrodn so firefox doesnt work on mac?

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