title: How to avoid locking on Insert into..Select
body: <p>I wrote some SQL queries to do ETL processing which heavily uses INSERT INTO ... SELECT type queries. I see Mysql replication stops frequently due to locking issue. I tried setting up almost all possible TRANSACTION ISOLATION LEVELs (READ UNCOMMITTED, COMMITTED) but none of them seems prevent to work. what are the possible ways to avoid this locking issue? </p>