Throttling backups with innobackupex

Although innobackupex does not block your database’s operation, any backup can add load to the system being backed up. On systems that do not have much spare I/O capacity, it might be helpful to throttle the rate at which innobackupex reads and writes InnoDB data. You can do this with the --throttle option.

This option is passed directly to xtrabackup binary and only limits the operations on the logs and files of InnoDB tables. It doesn’t have an effect on reading or writing files from tables with other storage engine.

One way of checking the current I/O operations at a system is with iostat command. See Throttling Backups for details of how throttling works.

The --throttle option is somehow similar to the --sleep option in mysqlbackup and should be used instead of it, as --sleep will be ignored.

Percona XtraBackup
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Previous topic

Accelerating with --parallel copy

Next topic

Sending Backups to Remote Hosts with innobackupex

This Page



© Copyright 2010-2012, Percona Ireland Ltd.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona XtraBackup source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>