partitioning

Locking Table Partitions in MySQL

A practical guide on how to lock specific table partitions in MySQL using WHERE clause.