TranscendLinux.com

for i in `mysql -B -e "show databases"|grep -v Database`; \
do for j in `mysql $i -B -e "show tables;"|grep -v Tables_`; \
do mysql $i -e "optimize table $j";done;done;