MySql数据库限制大小shell

#!/bin/sh

#du -h /www/db/mysqldb/data/ >DB_CONTROL_NUM.txt

#du -h /www/db/mysqldb/data/ |grep M | awk '{print $2}' >DB_CONTROL_NUM.txt

#du -s /www/db/mysqldb/data/* | awk '{print $2}' >DB_CONTROL_NUM.txt

cd /www/db/mysqldb/data/

ls | sed "s:^:`pwd`/:" >/usr/local/primahms/shell/DB_CONTROL_NUM.txt

cd /usr/local/primahms/shell

for i in $(cat DB_CONTROL_NUM.txt )

do

 #echo $num;

 num=`du -s $i | awk '{print $1}'`

 #num_T= $num - 50;

 #echo $num_T;

 if echo 600000-$num|bc|grep -E '^-' >>db_log.txt

 then

 #echo $num;

 echo $i >>db_log.txt;

 chmod 500 $i;

 fi

done

完整版：