#!/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