Temporary tables are awesome! But they are session-dependent. I am thinking of a scenario in which different scripts (different sessions) would generate data sets in parallel, and then they are combined.
Obviously, I can do all of this using flat file data dumps (what I do right now). But I was trying to understand my options. On Fri, May 8, 2020 at 5:07 PM Martin Urbanec <martin.urba...@wikimedia.cz> wrote: > Hmm, does create temporary table work? If not, can it? > > Martin > > On Fri, May 8, 2020, 11:04 PM Huji Lee <huji.h...@gmail.com> wrote: > >> I was thinking of running a query, temporarily store its output on >> ToolsDB. Join it with some other query and then throw it away. All in small >> scale and for short-term. >> >> On Fri, May 8, 2020 at 5:01 PM Brooke Storm <bst...@wikimedia.org> wrote: >> >>> No, the wikireplicas are read-only. >>> >>> That said, ToolsDB (Toolforge user DB) is not equipped to handle >>> becoming an aggregate datamart for the wiki replicas at any thing close to >>> large (wiki) scale--just small chunks that are ideally regularly cleaned >>> up. Are we talking about a database on a Cloud VPS instance or ToolsDB? >>> >>> Brooke Storm >>> SRE >>> Wikimedia Cloud servicesbst...@wikimedia.org >>> IRC: bstorm_ >>> >>> On 5/8/20 12:31 PM, Huji Lee wrote: >>> >>> Hi all, >>> Is it possible to store data into user tables through queries on >>> Wikireplica DBs? Or is it only possible by mysqldump'ing from the replica >>> DB and loading into the user table in a separate step? >>> I am thinking of aggregate data. >>> Thanks! >>> >>> _______________________________________________ >>> Wikimedia Cloud Services mailing listcl...@lists.wikimedia.org (formerly >>> lab...@lists.wikimedia.org)https://lists.wikimedia.org/mailman/listinfo/cloud >>> >>> >>> _______________________________________________ >>> Wikimedia Cloud Services mailing list >>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) >>> https://lists.wikimedia.org/mailman/listinfo/cloud >> >> _______________________________________________ >> Wikimedia Cloud Services mailing list >> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) >> https://lists.wikimedia.org/mailman/listinfo/cloud > > _______________________________________________ > Wikimedia Cloud Services mailing list > Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
