Skip to content

Instantly share code, notes, and snippets.

@vdbelt
Created June 2, 2020 18:31
Show Gist options
  • Save vdbelt/f76febfa83fd3f4518e8406fc157a305 to your computer and use it in GitHub Desktop.
Save vdbelt/f76febfa83fd3f4518e8406fc157a305 to your computer and use it in GitHub Desktop.
Mysql dump with ionice
ionice -c2 nice -n19 mysqldump --opt --single-transaction --quick --hex-blob --events --force --user=$MYSQLUSER -p $db | ionice -c2 nice -n19 gzip > sql_dump.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment