Re: [Cloud] Replica DB timeouts

2020-04-28 Thread Federico Leva (Nemo)
Thank you, makes sense. My "normal" queries seem ok now and the longer ones can wait until after the maintenance. Have a nice day, Federico ___ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.or

[Cloud] Replica DB timeouts

2020-04-28 Thread Federico Leva (Nemo)
[Again in the saga of me trying to query the revision and logging tables against comment text and usernames...] Am I dreaming or is the timeout on DB queries today something like 2 minutes? Is it a temporary measure? Is a query killer particularly aggressive due to some overload? Should we exp

Re: [Cloud] [Wikidata] [Wikidata-tech] wb_terms redesign

2019-04-25 Thread Federico Leva (Nemo)
Alaa Sarhan, 25/04/19 17:38: Full migration is not possible unfortunately due to the current capacity of database master node. Can you clarify whether it would also be too much load to write both to the new table and the old wb_terms table for a transition period (controlled by a configuratio

Re: [Cloud] [Cloud-announce] 57 VPS projects are candidates for deletion

2018-09-17 Thread Federico Leva (Nemo)
Andrew Bogott, 17/09/2018 16:52: If you see anything in this list that you care about, please indicate that the project is in use on the Wikitech page.  Here are the 57 projects that are currently unmarked: aicaptcha bots Not "my" project, but the "bots" instance still hosts the public IRC

[Cloud] Emulate cross-wiki joins

2018-01-17 Thread Federico Leva (Nemo)
I usually use bash or python scrips to query data from multiple wikis at once, but I wanted something "simple" in Quarry such as a list of users who are active in two wikis, and I felt very stupid. I ended up using two separate queries, a subquery and a mix of GROUP_CONCAT, TO_BASE64 and SET S