Re: What is the actual difference between innodb_autoinc_lock_mode 0,1,2

[Rick James]

> Using Option '2' -> It locks the entire table for each threads and loads the threads randomly picking each loads parellelly . To complete all 7 it took ~ 65Secs [Standard for all]. ofcourse it mixes and jumps the sequence of AIs for the next load data.

With SBR, I'm worried that the ids given to each row could be different when the LOADs are performed on the Slave.

Also, How long did the Slave take to do the LOADs? I suspect it was closer to 140 sec than to 65.

Some settings to consider tuning:
innodb_buffer_pool_size
innodb_log_file_size
binlog_cache_size
Use XtraDB instead of InnoDB -- performance is more consistent. (No, you did not mention this issue.)