май съм entirely obsessed..
root@clev5new:~# cat moodle.sh
#!/bin/bash

log=”/home/sentry/www/moodle_report”
echo “———————–Moodles with big cache tables———————–” >> $log
find /var/lib/mysql/* -type f -name “mdl_cache_text.MYI” -size +1500 | awk -F”/” ‘{print $5}’ >> $log
echo “———————–Moodles with big stats tables———————–” >> $log
find /var/lib/mysql/* -type f -name “mdl_stats_daily.MYI” -size +1500 | awk -F”/” ‘{print $5}’ >> $log
echo “———————–Calculating..—————————————” >> $log
for i in `cat $log |grep mdl`;
do
du -sh /var/lib/mysql/$i >> $log
du -sh /var/lib/mysql/$i/mdl_stats_daily.* >> $log
du -sh /var/lib/mysql/$i/mdl_cache_text.* >> $log
done;

---

root@clev5new:~# cat entire-moodle.sh
#!/bin/bash
log=”/home/sentry/www/entire_moodle_report”
find /var/lib/mysql/* -type f -name “mdl_user.MYI” | awk -F”/” ‘{print $5}’ >> $log
echo “———————– Calculation ———————–” >> $log
for i in `cat $log`;
do
du -sh /var/lib/mysql/$i >> $log
done;

Very neat tools for generating web based reports containing Moodle installations that have stats & cache (kewl overloadish) modules (the first script) and for such that does not have (all on our servers, at all). Useful. Mission completed, Master.

Long live bash scripting.

A neat tool for killing all the procs that belong to user

if [ "$1" == "" ]
then
echo “Usage: $0 username — will kill all processes that belong to the user and print them on the screen “
else

if [ "$1" == "root" ]
then
echo “Lapai..”
else
echo “The processes of $1 that were killed:”
echo “############################################”
ps -elf | grep “$1″
kill -9 `ps -u “$1″ | grep [0-9] | awk ‘{print $1}’`
fi
fi

сега май осъзнах колко съм тъжен. ебах го.