MySQL Forums
Forum List  »  Merge Storage Engine

merge tables and table locks
Posted by: Jay Nitikman
Date: March 13, 2007 04:17PM

We have a large MyISAM table that we are constantly inserting into and selecting from. There is a bottle neck because the INSERT's lock the entire table.
We are thinking of creating smaller base tables and merging them. We would INSERT into the base tables which would limit the locks to a smaller number of rows; and SELECT from the larger merge table.

Will this work? Will write locks on a base table also lock the merge table?

Thanks,

Jay

Options: ReplyQuote


Subject
Views
Written By
Posted
merge tables and table locks
7368
March 13, 2007 04:17PM
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.