loadcache.sh

#!/bin/sh

CMDNAME=$0

if [ $# -le 0 ] ;then
    echo "Usage: $CMDNAME database database ..."
fi

shift `expr $OPTIND - 1`
for database in $@ ;do
    tables=`mysql -uroot information_schema -sse "SELECT table_name FROM tables WHERE table_schema = '$database' AND engine = 'MyISAM'"`
    for table in $tables ;do
        echo "`date` LOAD INDEX INTO CACHE $table"
        mysql -uroot $database -e "LOAD INDEX INTO CACHE $table"
    done
done