InnoDB supports a number of lock modes to ensure that concurrent write operations never collide.