On Sun, May 10, 2020 at 4:55 PM Huji Lee huji.huji@gmail.com 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