Apr 18, 2013: http://dba.stackexchange.com/questions/40400/loading-data-in-mysql-using-load-data-infile-replication-safe/40402#40402Loading data in mysql using LOAD DATA INFILE, replication safe?
Apr 02, 2013: http://dba.stackexchange.com/questions/38998/mysql-slave-stuck-in-reading-event-from-the-relay-log/39032#39032MySQL slave stuck in "Reading event from the relay log"?
Jan 22, 2012: http://dba.stackexchange.com/questions/10723/mysql-shell-command-not-replicated-to-slave/11256#11256MySql shell command not replicated to slave
|2||replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/|
There are occasions when a group of SQL commands are executed individually in the same one-second timeframe. Why does this happen on a Slave?
Keep in mind that the Master may have executed many INSERTs, UPDATEs, and DELETEs, in parallel. However, the binary logs records them as serialized events. An event will include the TIMESTAMP of the SQL command followed by the SQL Command.
If 30 DML commands each took 1 second to complete on a Master at
On the Slave, when each command is read one-by-one, the timestamp will be
There are occasions when a group of SQL commands are executed as series of row changes.
This could easily happen with row based replication (binlog_format is set to
Here are three posts where I discuss how Replication handles
When you execute
The Slave will see a binlog event in its relay logs that will alert the Slave to read the entire CSV file. Then, when it see the
During the manifestation of the temp CSV file, the
Binary Logs are are to handle group commits for better performance. Notwithstanding, you should looking at the following
Therefore, once Seconds_Behind_Master is 0 for a long time, look for changes in these five fields in the