Linux下bash脚本:计算重新索引Table时间(三)

2014-11-24 08:54:31 ? 作者: ? 浏览: 1
txt >>ResultFinal.txt
awk '{$1=$82-$81} {print "Reindexing of database DB --t_bgate_eventinfo-- "++$1 " s"}' Result6.txt >>ResultFinal.txt


#find out the result which are >30min(1800 senconds)
awk '$6>1800' ResultFinal.txt >ResultSencond.txt


#transfer the unit "sencond" to "minute"
awk '$6=$6/60' ResultSencond.txt >ResultMin.txt
awk '$7="min"' ResultMin.txt>ResultMail.txt


#delete the temporary files
rm ./Result.txt
rm ./Result[1,2,3,4,5,6].txt
rm ./ResultFinal.txt
rm ./ResultSencond.txt
rm ./ResultMin.txt


#mail the result to the related email addresses.
mail -s "Reindex Result for you" junzhaoyi@gmail.com

-->

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: