docker内的zabbix自动清理数据库脚本

#!/bin/bash
mysql_user="zabbix"
mysql_pass="Passwd123."
date=`date -d $(date -d "-30 day" +%Y%m%d) +%s`
log='/var/log/mysql_delete.log'
docker_id=`docker ps -a |  awk '{print $1}'| grep -v "CONTAINER" `

/usr/bin/docker exec -it  ${docker_id}  mysql -u${mysql_user}  -p${mysql_pass} -e "
use zabbix;
DELETE FROM history WHERE 'clock' < ${date};
optimize table history;
DELETE FROM history_uint WHERE 'clock' < ${date};
optimize table history_uint;  "

if [ $? -eq 0 ];then
      echo -e "$(date "+%Y-%m-%d %H:%M:%S")  is finishing delete " >> ${log}
      echo ""
else
     echo -e "$(date "+%Y-%m-%d %H:%M:%S") is failure delete ">> ${log}
fi