I have to run this query for up to 4million rows in a online production database: "insert into t1 select from t2",
t1 has ID autoincrement column and already has some data.
we have statement based replication.
knowing that t1 will be accessed by other users during the query run.
will this lock the table during the query run or create data discrepancies between the master and the slave??