Cloud June 2019

cloud@lists.wikimedia.org

18 participants
13 discussions

Optimalizing a SQL query
by Martin Urbanec 04 Jun '19

04 Jun '19

Hello, I'm trying to run this query more fastly. Can you help me how to optimalize it? MariaDB [commonswiki_p]> select count(*) from logging_logindex where log_type="thanks" and log_title="Martin_Urbanec"; +----------+ | count(*) | +----------+ | 6 | +----------+ 1 row in set (8 min 42.87 sec) MariaDB [commonswiki_p]> It's supposed to provide web-accessible information, and it's not possible to wait 8 mins for completion. https://tools.wmflabs.org/sql-optimizer/ didn't offer any solution. Any suggestions? Martin

4 3

[Cloud-announce] cloudservices1003 rebuild on 2019-06-03
by Arturo Borrero Gonzalez 03 Jun '19

03 Jun '19

Hi! On 2019-06-03 UTC+2 14:00 (next monday) we will be rebuilding the cloudservices1003 server, that holds the designate service which serves DNS request for CloudVPS and Toolforge. We have a backup server -cloudservices1004-, so we don't expect a lot of downtime. But DNS queries are really fast, and there may be a lot of them that will fail while we stabilize the DNS service. Please reach out to the WMCS team if you need more details or have any doubts. regards. -- Arturo Borrero Gonzalez Operations Engineer / Wikimedia Cloud Services Wikimedia Foundation _______________________________________________ Wikimedia Cloud Services announce mailing list Cloud-announce(a)lists.wikimedia.org (formerly labs-announce(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud-announce

1 1

Upgrade to MariaDB 10.2
by Huji Lee 02 Jun '19

02 Jun '19

Hi all, Does anyone know when we will be upgrading the Clouds replica DBs to MariaDB 10.2? I am asking mainly because we are on 10.1.33, 10.3 is now out, and since 10.2 support for CTEs (WITH statements) has been added which is very handy. Thanks, Huji

3 4

2024

2023

2022

2021

2020

2019

2018

2017

Cloud June 2019