MySQL Forums
Forum List  »  Merge Storage Engine

Re: merge tables and table locks
Posted by: KimSeong Loh
Date: March 13, 2007 08:46PM

The write lock of the base table will only write lock the base table.

However, the Select on the Merge table will have to get the read lock on all the base table before it can execute, so the write lock on the base table will still block the read lock on the merge table.

Options: ReplyQuote


Subject
Views
Written By
Posted
7369
March 13, 2007 04:17PM
Re: merge tables and table locks
4795
March 13, 2007 08:46PM


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.