MySQL实现MYISAM表批量压缩的方法

#!/bin/bash
data_dir="/data/mysql/my_dbname/"
filelist=`ls $data_dir`
echo "MYISAMPACK BEGIN."
for filename in $filelist
do
  idx=`expr match "$filename" ".*.MYI"`
  if [[ $idx>0 ]]
  then
    /usr/bin/myisampack $data_dir$filename
  fi
done
echo "MYISAMPACK End. MYISAMCHK BEGIN."
for filename in $filelist
do
  idx=`expr match "$filename" ".*.MYI"`
  if [[ $idx>0 ]]
  then
    /usr/bin/myisamchk -r -o -f --sort-index --analyze $data_dir$filename
  fi
done
echo "MYISAMCHK END."