MySQL Forums
Forum List  »  InnoDB

Will inserts in Serializable transaction freeze the table?
Posted by: Marc M
Date: March 08, 2009 08:27PM

If I start a serializable transaction, and within that transaction I have an INSERT INTO statement, will all inserts into that table be frozen until this transaction is completed? I do not have a SELECT FOR UPDATE on this table. I want to use a transaction for other queries in this sequence, but if it freezes the table, it could eventually slow down other users. Any tips would be appreciated.

-Marc

------------------------
Inner space - what a trip.

Options: ReplyQuote


Subject
Views
Written By
Posted
Will inserts in Serializable transaction freeze the table?
3974
March 08, 2009 08:27PM


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.