mysql optimize table script

mysql optimize table script:

#!/bin/sh
#cocolala 2008/4/22
/usr/local/mysql/bin/mysql -uroot -pxxx db -s -e "show tables ;" >/tmp/tablelist.txt

for tablename in `cat /tmp/tablelist.txt`
do
/usr/local/mysql/bin/mysql -uroot -pxxx db -s -e \
"
optimize table ${tablename};
"
echo "optimize table ${tablename} ok "
done