insert stops insert in other tables
Hi!
When I copy a big table (i.e. INSERT INTO table2 SELECT * table1) all other INSERTs to other tables in the database seems to be queued behind this INSERT. Locking up my entire php app, even though the table I'm copying is not used in the app (just member of the same database). The table does not have any foreign keys. I use innodb. Why does this happen? I feel like there is something basic I've not understood about mysql.
Subject
Written By
Posted
insert stops insert in other tables
June 23, 2022 06:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.