MySQL Forums
Forum List  »  InnoDB

Why pure insert operation in master result in update and read operation in slave?
Posted by: feng guo
Date: February 28, 2016 09:38PM

I use multi threads to do pure insert operation in master,then I use orzdba to observer the mysql status as following picture:
http://itpubpic.img168.net/forum/201602/29/112229gg00q4kkaw0qvs4g.png

but when I observe in slave ,I found though the salve do also the pure insert operation,but the innodb rows influenced not only contains insert but also update and read operation,the orzdba's observation is as following:
http://itpubpic.img168.net/forum/201602/29/112230y323lzqs8squ99p9.png

I just do one thing all my life--do things interesting me!
Blog: www.leafonsword.org

Options: ReplyQuote


Subject
Views
Written By
Posted
Why pure insert operation in master result in update and read operation in slave?
1387
February 28, 2016 09:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.