Dump mysql process info and innodb status every 30 seconds

dump_mysql_proc_info.sh

#!/bin/bash

MYSQL_HOST=""
MYSQL_USER=""
MYSQL_PASSWORD=""
MYSQL_DB=""
CMD_INTERVAL=30 # 30sec

dump_info() {
  echo "==== $(date)"
  echo
  echo "======== SHOW FULL PROCESSLIST;"
  MYSQL_PWD=$MYSQL_PASSWORD mysql -u $MYSQL_USER -h $MYSQL_HOST $MYSQL_DB -e "SHOW FULL PROCESSLIST;"
  echo
  echo "======== SHOW ENGINE INNODB STATUS\G;"
  MYSQL_PWD=$MYSQL_PASSWORD mysql -u $MYSQL_USER -h $MYSQL_HOST $MYSQL_DB -e "SHOW ENGINE INNODB STATUS\G;"
  echo
}

while true; do
  dump_info
  sleep $CMD_INTERVAL
done