Edit file

File name : check_mysql_processes

Content :#!/bin/bash PNUM=$(sudo mysql -e "SELECT COUNT(*) FROM information_schema.PROCESSLIST;" | awk '{print $1}' | sed -n 2p) if [ "$PNUM" -ge 80 ]; then echo "CRITICAL: There are $PNUM processes. Probably stuck / sleeping." exit 2; elif [ "$PNUM" -ge 60 ]; then echo "WARNING: There are $PNUM processes." exit 1; else echo "OK" fi

Save