май съм 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.