Skip to content

Instantly share code, notes, and snippets.

@ronaldbradford

ronaldbradford/README.md

Last active November 18, 2022 19:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ronaldbradford/ed314eb5287cad58d17c2ff440e12e05 to your computer and use it in GitHub Desktop.
Save ronaldbradford/ed314eb5287cad58d17c2ff440e12e05 to your computer and use it in GitHub Desktop.
Download ZIP
Show MySQL Deadlock content from INNODB STATUS
Raw
README.md

Usage

mysql -u${DBA_USER} -p${DBA_PASSWD} -h ${INSTANCE_ENDPOINT} -e "SHOW ENGINE INNODB STATUS\G" | awk -f deadlock.awk
Raw
deadlock.awk
BEGIN { show=0; }
/^LATEST DETECTED DEADLOCK/ { show=1; }
/^TRANSACTIONS/ { show=0; }
{
if (show == 1) {
print $0
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment