Why does INSERT SELECT into an unrelated table block when SELECT doesn't? Mysql 5.6
Actually, INSERT INTO .. SELECT does lock the SELECT table

I wrote about this before


Apr 25, 2016 : MySQL INSERT ... SELECT Performance
Aug 08, 2014 : MySQL consistent nonlocking reads vs. INSERT ... SELECT (More Details)