Migrate Big Table in MySQL
Migrate MySQL big table(50 Million) rows using insert into xxx select * from yyy and it said ERROR 1206 (HY000): The total number of locks exceeds the lock table size It’s due to MySQL MVCC control, the rows were in memory and exceeds the limit. You can use this command to quickly find the limit: SELECT @@innodb_buffer_pool_size/1024/1024/1024; For me, that’s 0.125. So I changed it by this command: SET GLOBAL innodb_buffer_pool_size = 1073741824; 10x the original size, so everything works fine....