Hi I have a cron job to backup a lot of my database. I create a script to run the dump command for each database every night, I created it like this.
mysqldump --defaults-extra-file=$DEFAULT_FILE -e --compact --skip-comments $DATABASE -r $filename; [[ $? -eq 0 ]] && gzip $filename
Here is the my memory traffic for last 2 weeks. I run it for the first time at 2/12. It keep increases every time the cron is running. I try to shut it down at 2/16 to make sure it comes from the cron job. Any one know what's happen? or is anything wrong with my mysql dump command? I try to avoid restart mysql server every night.