MySQL Forums
Forum List  »  Partitioning

locking only needed Partitions when inserting.
Posted by: Aner Mazursky
Date: January 29, 2009 09:10AM

In an highly write-intensive DB, we encounter many situations where one
We're going to great lengths to make sure we never read from a partition we write to, but it seems like insert (both insert select and insert values) lock the entire table, even though the could lock only the relevant partitions (the select have an explicit condition on the output, which can say what is the partition)...

Is there any easy way to avoid those locks?

Options: ReplyQuote


Subject
Views
Written By
Posted
locking only needed Partitions when inserting.
2716
January 29, 2009 09:10AM


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.