I'm running an always-on script to pull data from an outside source and save it to my database on pythonanywhere (so I can then display that data on my django web app). I ran into a problem where I couldn't make any other changes to the database while this script was running, like migrating or deleting rows.
Running show processlist;
in a mysql console shows that the processes are Waiting for table metadata lock
I did some googling and there's some advice that setting the variable innodb_autoinc_lock_mode
to 2 (instead of the default, 1) can help with this problem. https://dba.stackexchange.com/a/193060
Is it possible to change these MySQL settings on pythonanywhere? I don't think I have admin access to the database. Otherwise, has anyone else encountered this problem? Advice is appreciated.