Re: Partitoned table and table locking

[Phil Hildebrand]

Are you saying you want to explicitly lock a partition, or are you asking if MySQL will lock a partition only if you insert a row into a given partition?

It depends a little on what you are asking. If you are using innodb, and inserting a row that ends up in partition 1, then only that row in partition 1 should get locked for write. If you are using myisam, then only partition 1 should get locked for write (the whole partition, but not the whole table).

If you alter a table and reorganize a set of partitions, then there should be a write lock on the whole table for the duration of the reorganize.

I don't believe there is any way to throw a specific lock on a partition however, without some kind of select for update.