mysql简单的碎片清理脚本

作者:阿川 发布时间:April 11, 2017 分类:服务器 点击:8196

#!/bin/bash 
date=`date +"%Y-%m-%d %H:%M:%S"` 
echo $date >>/root/information_schema.log 
tables=$(/usr/local/mysql/bin/mysql -u root -p"tina" 2>/dev/null -e "select concat(table_schema,'.',table_name) from 
information_schema.tables where data_free>0 and engine !='MEMORY';"
 |grep -v "concat" |grep -v "tinatest" |grep -v "information_schema" |grep -v "mysql") 
 
for table in $tables 
do 
  /usr/local/mysql/bin/mysql -u root-p"tina" 2>/dev/null -e "optimize no_write_to_binlog table $table;" >>/root/information_schema.log 
done

标签: none

添加新评论 »