Swap usage increased when mysqldump
Hi, is mysqldump keep increasing swap usage ?
because my swap usage is increased 10% at the time mysqldump running
This is my mysqldump script, it working ! but swap usage is increasing too
mysql_db_bak-GR.sh
bak_dir=/blj/db_bak
d=$(date -d "today" '+%Y-%m-%d-%H%M')
mysql -uadmindb -pmypass -h127.0.0.1 --execute="show master status\G;" > ${bak_dir}/$1_$d_'masterpos'.dump
mysqldump -uadmindb -pmysql_db_bak-GR.sh -h127.0.0.1 --no-create-info --single-transaction --quick --master-data=2 $1 > ${bak_dir}/$1_$d.dump
mysqldump -uadmindb -pmysql_db_bak-GR.sh -h127.0.0.1 --no-data $1 > ${bak_dir}/$1_$d_'schema'.dump
Subject
Views
Written By
Posted
Swap usage increased when mysqldump
1869
August 28, 2018 11:04PM
797
August 29, 2018 08:45AM
889
September 03, 2018 12:49AM
723
September 03, 2018 09:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.