Skip to content

Instantly share code, notes, and snippets.

View mithlajkn's full-sized avatar
🎯
Focusing : DevOps

Mohammed Mithlaj mithlajkn

🎯
Focusing : DevOps
View GitHub Profile
@mithlajkn
mithlajkn / threatboard.sh
Created June 5, 2022 09:52 — forked from jrsouth/threatboard.sh
SQL `watch` commands
watch -t -n 5 'echo -e "THREAT BOARD\n`date`\n\n TOP\n---------------------";top -b -n 1 | head -12 | tail -6; echo -e " \n df -h\n---------------------"; df -h | sort -g -k5; echo -e " \n free -m\n---------------------"; free -m; echo -e " \n MySQL\n---------------------"; mysql -e "SELECT COUNT(ID) AS \`NUMBER OF THREADS\` FROM INFORMATION_SCHEMA.PROCESSLIST;" | sed "$!{:a;N;s/\n/: /;ta}"; mysql -t -e "SELECT ID, USER, HOST, DB, STATE, COMMAND, TIME, SUBSTRING(INFO, 0, 20) AS QUERY FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY TIME DESC;";'