Understanding the Locking Mechanism of MySQL's SELECT FOR UPDATE Statement: A Study on Row-Level and Table-Level Locks.