My cronjob consumes 100% cpu even using ionice. Did I do something wrong?
for db in ${databases}; do
ionice -c 3 nice -19 mysqldump -h localhost...
wait
done
PS. Amazon Linux
My cronjob consumes 100% cpu even using ionice. Did I do something wrong?
for db in ${databases}; do
ionice -c 3 nice -19 mysqldump -h localhost...
wait
done
PS. Amazon Linux
You are setting nice and ionice priorities for mysqldump process which does not really consumes much, it only sends commands to mysqld process. You should lower priorities for mysqld or (much harder but much better way) setup a Mysql-slave server and make backups from it.