I have a query that tries to find pages in article namespace that contain a
link to some page in the user/user talk namespace. Many of these result
from users signing in the articles (which is obviously not appropriate).
The query also tries to exclude pages that have a legitimate link to user
pages; e.g. our {{under construction}} template contains a link to the user
page of the person who affixed the template, and we can easily find these
pages based on a category they get added to by the same template.
The query is very brief, and I have pasted it below. To the best of my
understand, it uses indexes and does not cause any USING WHERE or USING
FILESORT steps. Nevertheless, the query takes more than 30 minutes on Labs
and is killed as a result.
Is there a way to optimize this query further? If not, that is okay; I will
implement a two-step query. But I just want to make sure I'm not missing
something obvious.
Thanks,
Huji
SELECT
page_title,
pl_title,
CASE
WHEN c2.cl_to IS NULL THEN NULL
ELSE '{{yes}}'
END AS under_construction
FROM page
JOIN pagelinks
ON page_id = pl_from
LEFT JOIN categorylinks c2
ON page_id = c2.cl_from
AND c2.cl_to = 'صفحههای_گسترده_در_دست_ساخت'
WHERE
page_namespace = 0
AND pl_namespace IN (2, 3)
Hi there!
In a few days from now (2020-04-13), the CloudVPS network will see a change
happening that will likely go unnoticed, but it is important enough to share it
with you beforehand.
We will be changing the IPv4 address that we use as the main source NAT for
egress connections (initiated in the VM instances). This change won't affect VM
instances using floating IPs.
Old IP address: 185.15.56.1
New IP address: 208.80.155.92
If you know of anywhere (a firewall, ACL or any other mechanism) that had this
address hardcoded, you will need to update it.
See this wikitech page for more details:
https://wikitech.wikimedia.org/wiki/News/CloudVPS_NAT_change
Please reach out if you have any doubts, questions, or any other issue.
regards.
--
Arturo Borrero Gonzalez
SRE / Wikimedia Cloud Services
Wikimedia Foundation
Hi Everyone,
We’re happy to announce the April 2020 edition of the Technical Community
Newsletter
<https://www.mediawiki.org/wiki/Technical_Community_Newsletter/2020/April>.
The newsletter is compiled by the Wikimedia Developer Advocacy Team. It
aims to share highlights, news, and information of interest from and about
the Wikimedia technical community.
Check it out, and learn about what technical contributors have been up to
this past quarter, upcoming conferences & calls for papers, and how to get
involved.
The Wikimedia Technical Community is large and diverse, and we know we
can't capture everything perfectly. We welcome your ideas for future
newsletters. Let us know what you would like to see or highlights you would
like us to include.
Subscribe to the Technical Community Newsletter
<https://www.mediawiki.org/wiki/Newsletter:Technical_Community_Newsletter>,
if you'd like to keep up with essential updates and information.
Kindly,
Sarah R. Rodlund
Technical Writer, Developer Advocacy
<https://meta.wikimedia.org/wiki/Developer_Advocacy>
srodlund(a)wikimedia.org