Five mysql tricks to save your time while migrating huge data. Better use of indices, bulk insertion, deletion, inplace algorithm, and n+1 query problem.