As restoring a dump table into the MySQL master – you better get some sleep

(Ilan Hazan) Restoring a dump table into the MySQL master server can lead to serious replication delay. The massive inserts commands cause the Master and slaves to use most of their resources for replication. As a result, replication lag may increase dramatically (linear to the table size).

Read More - Register for Free Membership