<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:tahoma,new york,times,serif;font-size:12pt">>It took about 30 mins to load 1M records. No error messages I observe. <br><br>If you are doing this in a single transaction<br>IE: <br>BEGIN; insert 10m records; COMMIT;<br><div><br>Then the time it takes to replicate 10M would be about 5 hours.<br><br>IOW, the more records you change, the longer it takes. <br><br>However, have you checked how much physical disk space you have? If you don't have enough on the slave, then the transaction will abort and cause a rollback, which will take even longer to undo.<br><br><br></div><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font></div><br></div><br>
</body></html>