[Cloud] Changing my shell preference

Is there a way to change my preferred shell on the Clouds to zsh? When I try chsh -s `which zsh` it asks for a password, which I don't have of course. Thanks, Huji ___ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@li

Re: [Cloud] Help with a query

The query took more than an hour, so I killed it. I think a better strategy is to first run the query on logging, and get a list of logs, then run the subquery for retrieving the edit counts. My new query is shown below; however, I cannot create temporary tables with my user on Toolforge. I tried

Re: [Cloud] Help with a query

On Sat, Dec 30, 2017 at 2:10 PM, Maximilian Doerr < maximilian.do...@gmail.com> wrote: > Isn’t there a logging_logindex table to use that should optimize this? > It looks like logging_logindex is useful for queries that are targeting indexes page_time, log_page_id_time, and type_action. It looks

Re: [Cloud] Help with a query

There is a logging_logindex table. I incorporated all suggested changes into https://quarry.wmflabs.org/query/23829 Since I still think they query will take more than 20 minutes, I think quarry is not the way to go. I saved the query on the grid and tried to run it using this command: jsub -once

Re: [Cloud] Help with a query

Isn’t there a logging_logindex table to use that should optimize this? Cyberpower678 English Wikipedia Account Creation Team English Wikipedia Administrator Global User Renamer > On Dec 30, 2017, at 14:07, Brad Jorsch (Anomie) wrote: > > On Sat, Dec 30, 2017 at 1:07 PM, John

Re: [Cloud] Help with a query

On Sat, Dec 30, 2017 at 1:07 PM, John wrote: > Use the logging_userindex table instead of logging > That won't make much difference, since the select on the logging table isn't targeting any user columns. On Sat, Dec 30, 2017 at 1:09 PM, John wrote: > I would also find the first log of 2017 a

Re: [Cloud] Help with a query

All fantastic suggestions. The EXPLAIN results showed that changing to logging_userindex had potentially the largest impact (reducing the rows to be retrieved from 10mil to 5mil). I am rerunning the query with all suggested recommendations, and will report back. On Sat, Dec 30, 2017 at 1:32 PM, De

Re: [Cloud] Help with a query

On Sat, Dec 30, 2017 at 1:00 PM, Huji Lee wrote: > The query tries to use indexes, as much as I could think of > You missed using effective indexes. Let's start by getting the EXPLAIN output for your query. https://tools.wmflabs.org/tools-info/optimizer.py? doesn't seem to like the subquery for

Re: [Cloud] Help with a query

Replace count(*) with count(1) in the subquery. It could help (?) to improve the performance. Dennis Tobar Calderón (Enviado desde un móvil) El 30 dic. 2017 3:10 p. m., "John" escribió: > I would also find the first log of 2017 and use that instead of the > timestamp > > ___

Re: [Cloud] Help with a query

I would also find the first log of 2017 and use that instead of the timestamp ___ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Help with a query

Use the logging_userindex table instead of logging On Sat, Dec 30, 2017 at 12:01 PM Huji Lee wrote: > I wrote this query to find all page moves done in fawiki in 2017, and > determine how many edits the performing user had prior to that page move. > The query tries to use indexes, as much as I c

Re: [Cloud] Quarry slower than before

Oh, that's right! I do remember the discussion about changing to CNAMEs. I wonder if Quarry also keeps audit logs of the queries it ran and how long they took. It would be useful to display them in form of a trend line, for instance. On Sat, Dec 30, 2017 at 12:28 PM, Bryan Davis wrote: > On Sat

[Cloud] Help with a query

I wrote this query to find all page moves done in fawiki in 2017, and determine how many edits the performing user had prior to that page move. The query tries to use indexes, as much as I could think of, and yet it runs for a very long time (more than 20 min, at which point it gets killed). Any i

Re: [Cloud] Quarry slower than before

On Sat, Dec 30, 2017 at 9:51 AM, Huji Lee wrote: > I feel like Quarry is slower than before (before being last week or last > month). Queries almost always get queued, and once executed, simple queries > take longer to result. > > I have no idea how to investigate this though. Any thoughts? Quarr

[Cloud] Quarry slower than before

I feel like Quarry is slower than before (before being last week or last month). Queries almost always get queued, and once executed, simple queries take longer to result. I have no idea how to investigate this though. Any thoughts? Huji ___ Wikimedia C