V1rus Private

Viewing: check_mysql_processes

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

User / IP	: 216.73.217.108
Host / Server	: 190.92.174.125 / aerosofthealthcare.com
System	: Linux s3739.bom1.stableserver.net 4.18.0-513.24.1.lve.2.el8.x86_64 #1 SMP Fri May 24 12:42:50 UTC 2024 x86_64