On 4/1/20 2:16 PM, Arturo Borrero Gonzalez wrote:
> Hi there!
>
> If you use a CloudVPS web proxy, this email is for you. Toolforge
> developers/users can ignore this email.
>
> We are introducing a change to eliminate the 'X-Forwarded-For' HTTP header
> that
> the CloudVPS web proxy adds when f
Hello,
thanks for doing great job.
Do you have plan to enable HTTPS per default for web proxy names?
Best regards,
Zoran Dori
volunteer, Wikimedia Serbia
s: zoranzoki21.github.io e: zorandori4...@gmail.com
___
Wikimedia Cloud Services mailing list
Cloud
Not sure if this is an appropriate place to discuss this but I'm not
able to run this query:
https://quarry.wmflabs.org/query/24267
Even a minor part of this query like below needs a significant time to
complete.
SELECT count(*) as review_count, log_actor
FROM logging
WHERE log_type
Also note that I have a similar query that kind of works but takes much
longer to complete then it used to.
https://quarry.wmflabs.org/query/41680
Executed in 46.22 seconds as of Wed Jan 29 2020.
Resultset (1480 rows)
Executed in 188.32 seconds as of Wed Apr 15 2020.
Resultset (1480 rows)
So t
You should use the un(der)-documented `logging_logindex` view instead of
`logging`.
On Wed, Apr 15, 2020 at 17:56 Maciej Jaros wrote:
> Not sure if this is an appropriate place to discuss this but I'm not able
> to run this query:
> https://quarry.wmflabs.org/query/24267
>
> Even a minor part of
Alright, now that I've unearthed the page I was looking for, a fuller
answer.
The wiki replicas have to do a lot of database magic to remove
private/deleted data, which means that the normal tables can be slow.
For your logging query, logging_logindex makes things faster because
log_action is null
We'll be upgrading the cloud services OpenStack install tomorrow,
beginning at 15:00 UTC.
There should be little to no interruption to VMs or Toolforge, but
Horizon logins will be disabled for part of the window.
Sorry for the short notice!
- Andrew + the WMCS team
_
