Pessimistic Locking: Better MySQL Compatibility, Fewer Rollbacks Under High Load | Hacker News Reader