--throttle is not considered during apply-log

Bug #1349543 reported by Jay Janssen on 2014-07-28
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Low
Hrvoje Matijakovic
2.1
Fix Released
Low
Hrvoje Matijakovic
2.2
Fix Released
Low
Hrvoje Matijakovic

Bug Description

Xtrabackup 2.1.9

innobackup --apply-log (on an incremental, FWIW) does not seem to obey --throttle.

Mon Jul 28 18:50:33 UTC 2014 - /usr/bin/innobackupex --use-memory=1G --throttle=300 --apply-log /backup/full_backup --tmpdir=/mnt/tmp --incremental-dir=/backup/incremental_data 2>&1 >> /var/log/mysql/backup.log

140728 18:50:34 innobackupex: Starting ibbackup with command: xtrabackup_56 --defaults-file="/backup/full_backup/backup-my.cnf" --defaults-group="mysqld" --prepare --target-dir=/backup/full_backup --use-memory=1G --incremental-dir=/backup/incremental_data --tmpdir=/mnt/tmp

Notice while --throttle is set on the innobackupex line, it is not passed to xtrabackup. That may be an oversight, or it may be that xtrabackup_56 simply won't obey --throttle for --prepare anyway.

Tags: doc Edit Tag help

Related branches

Verified with Xtrabackup 2.1.9 and 2.2.3 with --apply-log, --throttle is not passed to xtrabackup.

nilnandan@nilnandan-Dell-XPS:~$ sudo /home/nilnandan/Downloads/percona-xtrabackup-2.1.9-Linux-x86_64/bin/innobackupex --throttle=30 --ibbackup=/home/nilnandan/Downloads/percona-xtrabackup-2.1.9-Linux-x86_64/bin/xtrabackup --apply-log /home/nilnandan/backup/2014-08-04_12-25-01

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

IMPORTANT: Please check that the apply-log run completes successfully.
           At the end of a successful apply-log run innobackupex
           prints "completed OK!".

140804 12:27:54 innobackupex: Starting ibbackup with command: /home/nilnandan/Downloads/percona-xtrabackup-2.1.9-Linux-x86_64/bin/xtrabackup --defaults-file="/home/nilnandan/backup/2014-08-04_12-25-01/backup-my.cnf" --defaults-group="mysqld" --prepare --target-dir=/home/nilnandan/backup/2014-08-04_12-25-01 --tmpdir=/tmp

-- ^^ no --throttle option

Same with 2.2.3

nilnandan@nilnandan-Dell-XPS:~$ xtrabackup --version
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
nilnandan@nilnandan-Dell-XPS:~$

nilnandan@nilnandan-Dell-XPS:~$ sudo innobackupex --throttle=30 --apply-log /home/nilnandan/backup/2014-08-04_12-31-28

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

IMPORTANT: Please check that the apply-log run completes successfully.
           At the end of a successful apply-log run innobackupex
           prints "completed OK!".

140804 12:32:11 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/home/nilnandan/backup/2014-08-04_12-31-28/backup-my.cnf" --defaults-group="mysqld" --prepare --target-dir=/home/nilnandan/backup/2014-08-04_12-31-28 --tmpdir=/tmp

Changed in percona-xtrabackup:
status: New → Confirmed
Alexey Kopytov (akopytov) wrote :

This page correctly says that the --throttle option only has effect with the --backup option:

http://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/throttling_backups.html

"
In --backup mode, this option limits the number of pairs of read-and-write operations per second that xtrabackup will perform. If you are creating an incremental backup, then the limit is the number of read IO operations per second.
"

And so does this page:

http://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/xbk_option_reference.html#cmdoption-xtrabackup--throttle

"
This option limits --backup to the specified number of read+write pairs of operations per second. See throttling a backup.
"

But the corresponding page describing the _innobackupex_ option does not say that:

http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/throttling_ibk.html

Neither does this page:

http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--throttle

Converting to a documentation request to make all innobackupex-related pages + built-in help in innobackupex itself consistent with the xtrabackup option description, i.e. make it clear that it only applies to the backup stage, not to the copy-backup or apply-log ones.

tags: added: doc

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-920

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers