Not the answer you need?
Register and ask your own question!

Insert into Select, table locking

kingshuksaha@hotmail.com[email protected] EntrantCurrent User Role Beginner
My organization, has a Master/Slave setup, replication mode is Mixed-mode. We have read queries/SP(s) running in Slave, having Insert into Select. Is all the source tables will get locked in Slave? If, yes, how can I avoid it. Slave is a read-only slave not a relay slave.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.