MySQL Forums :: InnoDB :: Creating non-locking temporary tables

Advanced Search

Creating non-locking temporary tables
Posted by: Billy Gilbert ()
Date: October 29, 2016 02:03PM

Hi there! I am having an issues with temporary tables that I was curious if anyone else had encountered before.

In our environment, we have slave servers that we are utilizing for the purposes of reporting. On those slave servers, we are creating temporary tables to stage data. If we happen to get a transaction from the master server that affects one of those rows, it is causing a deadlock that is breaking replication.

Is there a safe way to create temporary tables on a slave server that would not break replication should this situation occur?

Thank you!

Options: ReplyQuote

Subject Views Written By Posted
Creating non-locking temporary tables 432 Billy Gilbert 10/29/2016 02:03PM
Re: Creating non-locking temporary tables 256 Rick James 10/30/2016 05:16PM

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.