脚本编写如:
#!/bin/bash
/usr/bin/top -n -1 -u mysql > /root/script/log/$(date +"%Y%m%d_%H%M%S").LOG
报错如下:
解决办法:
将脚本加上-b参数即可
/usr/bin/top -bn -1 -u mysql > /root/script/log/$(date +"%Y%m%d_%H%M%S").LOG
crontab测试正常
crontab -e
*/1 * * * * /root/script/mysql.sh