MySQL Forums
Forum List  »  InnoDB

Re: create table as select block my insert
Posted by: Ofir Gilboa
Date: October 06, 2014 02:28PM

Hi Rick

let me explain.
my replication used for data analysis , which means that analysts select data from it and create tables on different database than the master is updating.
in this case when the analyst is doing CREATE TABLE...SELECT then it select a table from the main database but create table on its own database. no write permissions on the Master database.

Slave> CREATE TABLE...SELECT from X
Master> INSERT INTO X
Slave> INSERT INTO X (the replication thread run this)
...lock...(on the slave)

you can reproduce this scenario on a single DB with no replication
S1> CREATE TABLE Y AS SELECT * FROM X
S2> INSERT INTO X => ...lock...

Options: ReplyQuote


Subject
Views
Written By
Posted
2468
October 05, 2014 03:25PM
Re: create table as select block my insert
1439
October 06, 2014 02:28PM


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.