SQL `watch` commands

threatboard.sh

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;";'

watch commands

watch -t -n 10 'mysql -t -e "SELECT ID, USER, HOST, DB, STATE, TIME FROM INFORMATION_SCHEMA.PROCESSLIST where TIME > 10 AND COMMAND != \"Sleep\" AND DB != \"eximstats\" ORDER BY TIME;"'

watch -t -n 5 'mysql -t -e "SELECT ID, USER, HOST, DB, STATE, TIME, SUBSTRING(INFO, 0, 20) FROM INFORMATION_SCHEMA.PROCESSLIST where TIME > 2 AND COMMAND != \"Sleep\" AND DB != \"eximstats\" ORDER BY TIME;"'


watch -t -n .5 'mysql -t -e "SELECT ID, USER, HOST, DB, STATE, TIME, SUBSTRING(INFO, 0, 20) AS QUERY FROM INFORMATION_SCHEMA.PROCESSLIST WHERE DB != \"eximstats\" ORDER BY TIME DESC;"'


watch -t -n 5 'echo -e "\nTHREAT BOARD\n`date`\n\n"; mysql -t -e "SELECT ID, USER, HOST, DB, STATE, TIME, SUBSTRING(INFO, 0, 20) AS QUERY FROM INFORMATION_SCHEMA.PROCESSLIST where TIME > 2 AND COMMAND != \"Sleep\" AND DB != \"eximstats\" ORDER BY TIME;"'


watch -t -n 5 'echo -e "\nTHREAT BOARD\n`date`\n\n\n\nTOP\n---------------------\n";top -b -n 1 | head -12; echo -e " \n\n\nMySQL\n---------------------\n"; mysql -t -e "SELECT ID, USER, HOST, DB, STATE, COMMAND, TIME, SUBSTRING(INFO, 0, 20) AS QUERY FROM INFORMATION_SCHEMA.PROCESSLIST where TIME > 0 AND DB != \"eximstats\" ORDER BY TIME;";'



watch -t -n 5 'echo -e "\nTHREAT BOARD\n`date`\n\n\n\n  TOP\n---------------------\n";top -b -n 1 | head -12; echo -e " \n\n\n  MySQL\n---------------------\n"; 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;";'