好用shell脚本

[root@mysql-db-87 sudouser]# cat  /data/shell/iocheck.sh
#!/bin/bash

user=''
password=''
master_ip='127.0.0.1'
format_ip='192-168-100-87'
port=3301

date=`date '+%Y%m%d_%H_%M_%S'`
log=/data/iotmp/io_${format_ip}_${date}.log

date_time=`date +%Y%m%d%H%M%S`



/usr/bin/iostat -xm 2 -t 2|grep sdb|tail -n 1|awk '{print $12}' >/tmp/io.log
num_ioutil=`cat /tmp/io.log|awk -F'.' '{print $1}'`



if [ $num_ioutil -ge 95 ];then
echo -e "io %util>=100% , need trouble shooting----------" >> $log
/usr/local/mysql/bin/mysql  -u$user -p$password -h$master_ip -P$port -e "select * from information_schema.PROCESSLIST  where INFO is not null;" >> $log
/usr/bin/pidstat -d 1 2
/usr/bin/top -n 2
#    ceurl 'http:{"contnt": "Alarm network is not good ping.sh"}}'
fi


##################
rename 脚本

#!/bin/bash

user=''
password=''
sock='/tmp/mysqld.3306_xxxx.sock'
tablename=`cat /data/shell/tablename`

#date=`date '+%Y%m%d_%H_%M_%S'`

date_time=`date +%Y%m%d%`

for i in $tablename
do
/usr/local/mysql/bin/mysql -u$user -p$password -S$sock -e "rename table kuming.$i to kuming._old_${i}_20211020"
done