Percona XtraBackup moved to https://jira.percona.com/projects/PXB

--throttle is not considered during apply-log

Bug #1349543 reported by Jay Janssen
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

Related branches

lp:~hrvojem/percona-xtrabackup/bug1355652-2.1
Alexey Kopytov (community): Approve
Diff: 225 lines (+42/-38)
13 files modified
doc/source/conf.py (+2/-0)
doc/source/faq.rst (+1/-1)
doc/source/glossary.rst (+3/-0)
doc/source/howtos/setting_up_replication.rst (+1/-1)
doc/source/index.rst (+1/-0)
doc/source/innobackupex/creating_a_backup_ibk.rst (+1/-1)
doc/source/innobackupex/how_innobackupex_works.rst (+1/-1)
doc/source/innobackupex/innobackupex_option_reference.rst (+1/-1)
doc/source/innobackupex/innobackupex_script.rst (+0/-2)
doc/source/innobackupex/throttling_ibk.rst (+4/-0)
doc/source/installation/apt_repo.rst (+7/-7)
doc/source/installation/yum_repo.rst (+7/-24)
doc/source/known_issues.rst (+13/-0)
lp:~hrvojem/percona-xtrabackup/bug1355652-2.2
Alexey Kopytov (community): Approve
Diff: 240 lines (+42/-47)
13 files modified
storage/innobase/xtrabackup/doc/source/conf.py (+2/-0)
storage/innobase/xtrabackup/doc/source/faq.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/glossary.rst (+3/-0)
storage/innobase/xtrabackup/doc/source/howtos/setting_up_replication.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/index.rst (+1/-0)
storage/innobase/xtrabackup/doc/source/innobackupex/creating_a_backup_ibk.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/innobackupex/how_innobackupex_works.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_option_reference.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_script.rst (+0/-2)
storage/innobase/xtrabackup/doc/source/innobackupex/throttling_ibk.rst (+4/-0)
storage/innobase/xtrabackup/doc/source/installation/apt_repo.rst (+7/-7)
storage/innobase/xtrabackup/doc/source/installation/yum_repo.rst (+7/-33)
storage/innobase/xtrabackup/doc/source/known_issues.rst (+13/-0)
Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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
Revision history for this message
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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.