On Sun, May 10, 2020 at 4:55 PM Huji Lee <[email protected]> wrote: > > 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'
Temporary tables are not supported on the Wiki Replica servers. See <https://phabricator.wikimedia.org/T179628> for discussion. The TL;DR is that MySQL/MariaDB's temporary tables can cause locking which in turn causes replication lag. Bryan -- Bryan Davis Technical Engagement Wikimedia Foundation Principal Software Engineer Boise, ID USA [[m:User:BDavis_(WMF)]] irc: bd808 _______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
