Log Innodb Deadlocks

log_deadlocks.sh

#!/bin/bash

dir=/root/deadlocks

[ -d $dir ] || mkdir -p $dir
cd $dir || { echo "Could not cd to $dir"; exit 1; }
mysql -be 'show engine innodb status;' \
  | sed 's/\\n/\n/g' \
  | awk '/TRANSACTIONS/{flag=0}flag;/LATEST DETECTED DEADLOCK/{flag=1}' \
  > latest.txt
filename=$(head -n 2 latest.txt | tail -n 1)
if [ -f previous.txt ]; then
  diff --brief latest.txt previous.txt > /dev/null
  if [ $? -eq 1 ]; then
    cp latest.txt "$filename.txt"
  fi
else
  cp latest.txt "$filename.txt"
fi
mv latest.txt previous.txt