Coming back to this comment from Martin: how can we use temporary tables on Labs? They don't seem to be available on a connection to wiki replica DBs:
MariaDB [fawiki_p]> create temporary table tmp(i int); ERROR 1044 (42000): Access denied for user 's12345'@'%' to database 'fawiki_p' On Fri, May 8, 2020 at 5:07 PM Martin Urbanec <[email protected]> wrote: > Hmm, does create temporary table work? If not, can it? > > Martin > > On Fri, May 8, 2020, 11:04 PM Huji Lee <[email protected]> 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 <[email protected]> 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 [email protected] >>> 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 [email protected] (formerly >>> [email protected])https://lists.wikimedia.org/mailman/listinfo/cloud >>> >>> >>> _______________________________________________ >>> Wikimedia Cloud Services mailing list >>> [email protected] (formerly [email protected]) >>> https://lists.wikimedia.org/mailman/listinfo/cloud >> >> _______________________________________________ >> Wikimedia Cloud Services mailing list >> [email protected] (formerly [email protected]) >> https://lists.wikimedia.org/mailman/listinfo/cloud > > _______________________________________________ > Wikimedia Cloud Services mailing list > [email protected] (formerly [email protected]) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
