I can't find any details on optimistic locking in MySQL. I read that starting a transaction keep updates on two …