List:Internals« Previous MessageNext Message »
From:Rich Prohaska Date:September 27 2012 4:27pm
Subject:execution of the update rows event on a replication slave in mysql 5.6.6-m9
View as plain text  
Hello,

We noticed that the 5.6.6-m9 code that handles the update rows log
event on a slave looks as if it no longer fetches the row as MySQL 5.5
does (5.5 calls find_row to fetch the row) before calling the storage
engine update_row method.   Here are some questions:

1. Is it in fact the case that 5.6 does not read the row when
executing update log events on the slave?  The log event has the
before and after update versions of the row, so reading the row seems
redundant.

2. Why was this change made?

3. Can the same change be applied to MySQL 5.5?  If so, are there any
addition changed needed?

Thanks
Rich Prohaska
Thread
execution of the update rows event on a replication slave in mysql 5.6.6-m9Rich Prohaska27 Sep
Re: execution of the update rows event on a replication slave inmysql 5.6.6-m9Rohit Kalhans3 Oct