MySQL Forums
Forum List  »  Newbie

insert stops insert in other tables
Posted by: Emil Edeholt
Date: June 23, 2022 06:39AM

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.

Options: ReplyQuote


Subject
Written By
Posted
insert stops insert in other tables
June 23, 2022 06:39AM


Sorry, only registered users may post in this forum.

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.