Merge lp:~hrvojem/percona-xtrabackup/bug1264622-2.1 into lp:percona-xtrabackup/2.1

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Alexey Kopytov
Approved revision: no longer in the source branch.
Merged at revision: 748
Proposed branch: lp:~hrvojem/percona-xtrabackup/bug1264622-2.1
Merge into: lp:percona-xtrabackup/2.1
Diff against target: 229 lines (+31/-32)
4 files modified
doc/source/conf.py (+0/-2)
doc/source/innobackupex/innobackupex_option_reference.rst (+11/-10)
doc/source/intro.rst (+2/-2)
doc/source/xtrabackup_bin/xbk_option_reference.rst (+18/-18)
To merge this branch: bzr merge lp:~hrvojem/percona-xtrabackup/bug1264622-2.1
Reviewer Review Type Date Requested Status
Alexey Kopytov (community) Approve
Review via email: mp+219955@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc/source/conf.py'
--- doc/source/conf.py 2014-05-06 09:52:54 +0000
+++ doc/source/conf.py 2014-05-18 08:24:16 +0000
@@ -118,8 +118,6 @@
118118
119.. |MySQL| replace:: *MySQL*119.. |MySQL| replace:: *MySQL*
120120
121.. |Drizzle| replace:: *Drizzle*
122
123.. |MariaDB| replace:: *MariaDB*121.. |MariaDB| replace:: *MariaDB*
124122
125.. |tar4ibd| replace:: :program:`tar4ibd`123.. |tar4ibd| replace:: :program:`tar4ibd`
126124
=== modified file 'doc/source/innobackupex/innobackupex_option_reference.rst'
--- doc/source/innobackupex/innobackupex_option_reference.rst 2014-03-15 12:18:51 +0000
+++ doc/source/innobackupex/innobackupex_option_reference.rst 2014-05-18 08:24:16 +0000
@@ -22,11 +22,11 @@
2222
23 This option instructs xtrabackup to compress backup copies of InnoDB data files. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for details.23 This option instructs xtrabackup to compress backup copies of InnoDB data files. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for details.
2424
25.. option:: --compress-threads25.. option:: --compress-threads=#
2626
27 This option specifies the number of worker threads that will be used for parallel compression. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for details.27 This option specifies the number of worker threads that will be used for parallel compression. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for details.
2828
29.. option:: --compress-chunk-size29.. option:: --compress-chunk-size=#
3030
31 This option specifies the size of the internal working buffer for each compression thread, measured in bytes. It is passed directly to the xtrabackup child process. The default value is 64K. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for details.31 This option specifies the size of the internal working buffer for each compression thread, measured in bytes. It is passed directly to the xtrabackup child process. The default value is 64K. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for details.
3232
@@ -70,11 +70,11 @@
7070
71 This option instructs xtrabackup to use the encryption key stored in the given ENCRYPTION_KEY_FILE when using the --encrypt option. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for more details.71 This option instructs xtrabackup to use the encryption key stored in the given ENCRYPTION_KEY_FILE when using the --encrypt option. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for more details.
7272
73.. option:: --encrypt-threads73.. option:: --encrypt-threads=#
7474
75 This option specifies the number of worker threads that will be used for parallel encryption. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for more details.75 This option specifies the number of worker threads that will be used for parallel encryption. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for more details.
7676
77.. option:: --encrypt-chunk-size 77.. option:: --encrypt-chunk-size=#
7878
79 This option specifies the size of the internal working buffer for each encryption thread, measured in bytes. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for more details.79 This option specifies the size of the internal working buffer for each encryption thread, measured in bytes. It is passed directly to the xtrabackup child process. See the :program:`xtrabackup` :doc:`documentation <../xtrabackup_bin/xtrabackup_binary>` for more details.
8080
@@ -122,7 +122,7 @@
122122
123 This option accepts a string argument that specifies the directory where the incremental backup will be combined with the full backup to make a new full backup. It is used with the :option:`--incremental` option.123 This option accepts a string argument that specifies the directory where the incremental backup will be combined with the full backup to make a new full backup. It is used with the :option:`--incremental` option.
124124
125.. option:: --incremental-lsn125.. option:: --incremental-lsn=LSN
126126
127 This option accepts a string argument that specifies the log sequence number (:term:`LSN`) to use for the incremental backup. It is used with the :option:`--incremental` option. It is used instead of specifying :option:`--incremental-basedir`. For databases created by *MySQL* and *Percona Server* 5.0-series versions, specify the as two 32-bit integers in high:low format. For databases created in 5.1 and later, specify the LSN as a single 64-bit integer.127 This option accepts a string argument that specifies the log sequence number (:term:`LSN`) to use for the incremental backup. It is used with the :option:`--incremental` option. It is used instead of specifying :option:`--incremental-basedir`. For databases created by *MySQL* and *Percona Server* 5.0-series versions, specify the as two 32-bit integers in high:low format. For databases created in 5.1 and later, specify the LSN as a single 64-bit integer.
128128
@@ -146,7 +146,7 @@
146146
147 This option specifies which types of queries are allowed to complete before innobackupex will issue the global lock. Default is all.147 This option specifies which types of queries are allowed to complete before innobackupex will issue the global lock. Default is all.
148148
149.. option:: --log-copy-interval149.. option:: --log-copy-interval=#
150150
151 This option specifies time interval between checks done by log copying thread in milliseconds.151 This option specifies time interval between checks done by log copying thread in milliseconds.
152152
@@ -159,6 +159,7 @@
159 Use this option to disable table lock with ``FLUSH TABLES WITH READ LOCK``. Use it only if ALL your tables are InnoDB and you **DO NOT CARE** about the binary log position of the backup. This option shouldn't be used if there are any ``DDL`` statements being executed or if any updates are happening on non-InnoDB tables (this includes the system MyISAM tables in the *mysql* database), otherwise it could lead to an inconsistent backup. 159 Use this option to disable table lock with ``FLUSH TABLES WITH READ LOCK``. Use it only if ALL your tables are InnoDB and you **DO NOT CARE** about the binary log position of the backup. This option shouldn't be used if there are any ``DDL`` statements being executed or if any updates are happening on non-InnoDB tables (this includes the system MyISAM tables in the *mysql* database), otherwise it could lead to an inconsistent backup.
160 If you are considering to use :option:`--no-lock` because your backups are failing to acquire the lock, this could be because of incoming replication events preventing the lock from succeeding. Please try using :option:`--safe-slave-backup` to momentarily stop the replication slave thread, this may help the backup to succeed and you then don't need to resort to using this option.160 If you are considering to use :option:`--no-lock` because your backups are failing to acquire the lock, this could be because of incoming replication events preventing the lock from succeeding. Please try using :option:`--safe-slave-backup` to momentarily stop the replication slave thread, this may help the backup to succeed and you then don't need to resort to using this option.
161 :file:`xtrabackup_binlog_info` is not created when --no-lock option is used (because ``SHOW MASTER STATUS`` may be inconsistent), but under certain conditions :file:`xtrabackup_binlog_pos_innodb` can be used instead to get consistent binlog coordinates as described in :ref:`working_with_binlogs`.161 :file:`xtrabackup_binlog_info` is not created when --no-lock option is used (because ``SHOW MASTER STATUS`` may be inconsistent), but under certain conditions :file:`xtrabackup_binlog_pos_innodb` can be used instead to get consistent binlog coordinates as described in :ref:`working_with_binlogs`.
162
162.. option:: --no-timestamp163.. option:: --no-timestamp
163164
164 This option prevents creation of a time-stamped subdirectory of the ``BACKUP-ROOT-DIR`` given on the command line. When it is specified, the backup is done in ``BACKUP-ROOT-DIR`` instead.165 This option prevents creation of a time-stamped subdirectory of the ``BACKUP-ROOT-DIR`` given on the command line. When it is specified, the backup is done in ``BACKUP-ROOT-DIR`` instead.
@@ -199,7 +200,7 @@
199200
200 Stop slave SQL thread and wait to start backup until ``Slave_open_temp_tables`` in ``SHOW STATUS`` is zero. If there are no open temporary tables, the backup will take place, otherwise the SQL thread will be started and stopped until there are no open temporary tables. The backup will fail if ``Slave_open_temp_tables`` does not become zero after :option:`--safe-slave-backup-timeout` seconds. The slave SQL thread will be restarted when the backup finishes.201 Stop slave SQL thread and wait to start backup until ``Slave_open_temp_tables`` in ``SHOW STATUS`` is zero. If there are no open temporary tables, the backup will take place, otherwise the SQL thread will be started and stopped until there are no open temporary tables. The backup will fail if ``Slave_open_temp_tables`` does not become zero after :option:`--safe-slave-backup-timeout` seconds. The slave SQL thread will be restarted when the backup finishes.
201202
202.. option:: --safe-slave-backup-timeout203.. option:: --safe-slave-backup-timeout=SECONDS
203204
204 How many seconds :option:`--safe-slave-backup`` should wait for ``Slave_open_temp_tables`` to become zero. Defaults to 300 seconds.205 How many seconds :option:`--safe-slave-backup`` should wait for ``Slave_open_temp_tables`` to become zero. Defaults to 300 seconds.
205206
@@ -211,11 +212,11 @@
211212
212 This option is useful when backing up a replication slave server. It prints the binary log position and name of the master server. It also writes this information to the :file:`xtrabackup_slave_info` file as a ``CHANGE MASTER`` command. A new slave for this master can be set up by starting a slave server on this backup and issuing a ``CHANGE MASTER`` command with the binary log position saved in the :file:`xtrabackup_slave_info` file.213 This option is useful when backing up a replication slave server. It prints the binary log position and name of the master server. It also writes this information to the :file:`xtrabackup_slave_info` file as a ``CHANGE MASTER`` command. A new slave for this master can be set up by starting a slave server on this backup and issuing a ``CHANGE MASTER`` command with the binary log position saved in the :file:`xtrabackup_slave_info` file.
213214
214.. option:: --socket215.. option:: --socket=SOCKET
215216
216 This option accepts a string argument that specifies the socket to use when connecting to the local database server with a UNIX domain socket. It is passed to the mysql child process without alteration. See :command:`mysql --help` for details.217 This option accepts a string argument that specifies the socket to use when connecting to the local database server with a UNIX domain socket. It is passed to the mysql child process without alteration. See :command:`mysql --help` for details.
217218
218.. option:: --sshopt = SSH-OPTIONS219.. option:: --sshopt=SSH-OPTIONS
219220
220 This option accepts a string argument that specifies the command line options to pass to :command:`ssh` when the option :option:`--remost-host` is specified.221 This option accepts a string argument that specifies the command line options to pass to :command:`ssh` when the option :option:`--remost-host` is specified.
221222
@@ -235,7 +236,7 @@
235236
236 This option accepts a string argument that specifies the location where a temporary file will be stored. It may be used when :option:`--stream` is specified. For these options, the transaction log will first be stored to a temporary file, before streaming or copying to a remote host. This option specifies the location where that temporary file will be stored. If the option is not specified, the default is to use the value of ``tmpdir`` read from the server configuration. innobackupex is passing the tmpdir value specified in my.cnf as the --target-dir option to the xtrabackup binary. Both [mysqld] and [xtrabackup] groups are read from my.cnf. If there is tmpdir in both, then the value being used depends on the order of those group in my.cnf.237 This option accepts a string argument that specifies the location where a temporary file will be stored. It may be used when :option:`--stream` is specified. For these options, the transaction log will first be stored to a temporary file, before streaming or copying to a remote host. This option specifies the location where that temporary file will be stored. If the option is not specified, the default is to use the value of ``tmpdir`` read from the server configuration. innobackupex is passing the tmpdir value specified in my.cnf as the --target-dir option to the xtrabackup binary. Both [mysqld] and [xtrabackup] groups are read from my.cnf. If there is tmpdir in both, then the value being used depends on the order of those group in my.cnf.
237238
238.. option:: --use-memory239.. option:: --use-memory=#
239240
240 This option accepts a string argument that specifies the amount of memory in bytes for :program:`xtrabackup` to use for crash recovery while preparing a backup. Multiples are supported providing the unit (e.g. 1MB, 1M, 1GB, 1G). It is used only with the option :option:`--apply-log`. It is passed directly to xtrabackup's :option:`xtrabackup --use-memory` option. See the |xtrabackup| documentation for details.241 This option accepts a string argument that specifies the amount of memory in bytes for :program:`xtrabackup` to use for crash recovery while preparing a backup. Multiples are supported providing the unit (e.g. 1MB, 1M, 1GB, 1G). It is used only with the option :option:`--apply-log`. It is passed directly to xtrabackup's :option:`xtrabackup --use-memory` option. See the |xtrabackup| documentation for details.
241242
242243
=== modified file 'doc/source/intro.rst'
--- doc/source/intro.rst 2013-08-30 09:55:04 +0000
+++ doc/source/intro.rst 2014-05-18 08:24:16 +0000
@@ -15,9 +15,9 @@
1515
16* Higher uptime due to faster restore time16* Higher uptime due to faster restore time
1717
18|XtraBackup| makes |MySQL| hot backups for all versions of |Percona Server|, |MySQL|, |MariaDB|, and |Drizzle|. It performs streaming, compressed, and incremental |MySQL| backups.18|Percona XtraBackup| makes |MySQL| hot backups for all versions of |Percona Server|, |MySQL|, and |MariaDB|. It performs streaming, compressed, and incremental |MySQL| backups.
1919
20|Percona XtraBackup| works with |MySQL|, |MariaDB|, |Percona Server|, and |Drizzle| databases (support for |Drizzle| is beta). It supports completely non-blocking backups of |InnoDB|, |XtraDB|, and *HailDB* storage engines. In addition, it can back up the following storage engines by briefly pausing writes at the end of the backup: |MyISAM|, :term:`Merge <.MRG>`, and :term:`Archive <.ARM>`, including partitioned tables, triggers, and database options.20|Percona XtraBackup| works with |MySQL|, |MariaDB|, and |Percona Server|. It supports completely non-blocking backups of |InnoDB|, |XtraDB|, and *HailDB* storage engines. In addition, it can back up the following storage engines by briefly pausing writes at the end of the backup: |MyISAM|, :term:`Merge <.MRG>`, and :term:`Archive <.ARM>`, including partitioned tables, triggers, and database options.
2121
22Percona's enterprise-grade commercial `MySQL Support <http://www.percona.com/mysql-support/>`_ contracts include support for |Percona XtraBackup|. We recommend support for critical production deployments.22Percona's enterprise-grade commercial `MySQL Support <http://www.percona.com/mysql-support/>`_ contracts include support for |Percona XtraBackup|. We recommend support for critical production deployments.
2323
2424
=== modified file 'doc/source/xtrabackup_bin/xbk_option_reference.rst'
--- doc/source/xtrabackup_bin/xbk_option_reference.rst 2013-11-15 12:42:15 +0000
+++ doc/source/xtrabackup_bin/xbk_option_reference.rst 2014-05-18 08:24:16 +0000
@@ -25,11 +25,11 @@
2525
26 This option tells |xtrabackup| to compress all output data, including the transaction log file and meta data files, using the specified compression algorithm. The only currently supported algorithm is 'quicklz'. The resulting files have the qpress archive format, i.e. every `*.qp` file produced by xtrabackup is essentially a one-file qpress archive and can be extracted and uncompressed by the `qpress <http://www.quicklz.com/>`_ file archiver.26 This option tells |xtrabackup| to compress all output data, including the transaction log file and meta data files, using the specified compression algorithm. The only currently supported algorithm is 'quicklz'. The resulting files have the qpress archive format, i.e. every `*.qp` file produced by xtrabackup is essentially a one-file qpress archive and can be extracted and uncompressed by the `qpress <http://www.quicklz.com/>`_ file archiver.
2727
28.. option:: --compress-chunk-size28.. option:: --compress-chunk-size=#
2929
30 Size of working buffer(s) for compression threads in bytes. The default value is 64K.30 Size of working buffer(s) for compression threads in bytes. The default value is 64K.
3131
32.. option:: --compress-threads 32.. option:: --compress-threads=#
3333
34 This option specifies the number of worker threads used by |xtrabackup| for parallel data compression. This option defaults to 1. Parallel compression ('--compress-threads') can be used together with parallel file copying ('--parallel'). For example, '--parallel=4 --compress --compress-threads=2' will create 4 IO threads that will read the data and pipe it to 2 compression threads. 34 This option specifies the number of worker threads used by |xtrabackup| for parallel data compression. This option defaults to 1. Parallel compression ('--compress-threads') can be used together with parallel file copying ('--parallel'). For example, '--parallel=4 --compress --compress-threads=2' will create 4 IO threads that will read the data and pipe it to 2 compression threads.
3535
@@ -37,19 +37,19 @@
3737
38 This option is not currently implemented. To create the InnoDB log files, you must prepare the backup twice at present.38 This option is not currently implemented. To create the InnoDB log files, you must prepare the backup twice at present.
3939
40.. option:: --datadir40.. option:: --datadir=DIRECTORY
4141
42 The source directory for the backup. This should be the same as the datadir for your MySQL server, so it should be read from :file:`my.cnf` if that exists; otherwise you must specify it on the command line.42 The source directory for the backup. This should be the same as the datadir for your MySQL server, so it should be read from :file:`my.cnf` if that exists; otherwise you must specify it on the command line.
4343
44.. option:: --defaults-extra-file=#44.. option:: --defaults-extra-file=[MY.CNF]
4545
46 Read this file after the global files are read. Must be given as the first option on the command-line.46 Read this file after the global files are read. Must be given as the first option on the command-line.
4747
48.. option:: --defaults-file=#48.. option:: --defaults-file=[MY.CNF]
4949
50 Only read default options from the given file. Must be given as the first option on the command-line. Must be a real file; it cannot be a symbolic link.50 Only read default options from the given file. Must be given as the first option on the command-line. Must be a real file; it cannot be a symbolic link.
5151
52.. option:: --defaults-group52.. option:: --defaults-group=GROUP-NAME
5353
54 This option is to set the group which should be read from the configuration file. This is used by innobackupex if you use the `--defaults-group` option. It is needed for mysqld_multi deployments.54 This option is to set the group which should be read from the configuration file. This is used by innobackupex if you use the `--defaults-group` option. It is needed for mysqld_multi deployments.
5555
@@ -57,15 +57,15 @@
5757
58 Create files necessary for exporting tables. See :doc:`Restoring Individual Tables <restoring_individual_tables>`.58 Create files necessary for exporting tables. See :doc:`Restoring Individual Tables <restoring_individual_tables>`.
5959
60.. option:: --extra-lsndir=name 60.. option:: --extra-lsndir=DIRECTORY
6161
62 (for --backup): save an extra copy of the xtrabackup_checkpoints file in this directory.62 (for --backup): save an extra copy of the xtrabackup_checkpoints file in this directory.
6363
64.. option:: --incremental-basedir64.. option:: --incremental-basedir=DIRECTORY
6565
66 When creating an incremental backup, this is the directory containing the full backup that is the base dataset for the incremental backups.66 When creating an incremental backup, this is the directory containing the full backup that is the base dataset for the incremental backups.
6767
68.. option:: --incremental-dir68.. option:: --incremental-dir=DIRECTORY
6969
70 When preparing an incremental backup, this is the directory where the incremental backup is combined with the full backup to make a new full backup.70 When preparing an incremental backup, this is the directory where the incremental backup is combined with the full backup to make a new full backup.
7171
@@ -73,11 +73,11 @@
7373
74 When creating an incremental backup, force a full scan of the data pages in the instance being backuped even if the complete changed page bitmap data is available.74 When creating an incremental backup, force a full scan of the data pages in the instance being backuped even if the complete changed page bitmap data is available.
7575
76.. option:: --incremental-lsn=name76.. option:: --incremental-lsn=LSN
7777
78 When creating an incremental backup, you can specify the log sequence number (:term:`LSN`) instead of specifying :option:`--incremental-basedir`. For databases created by *MySQL* and *Percona Server* 5.0-series versions, specify the :term:`LSN` as two 32-bit integers in high:low format. For databases created in 5.1 and later, specify the :term:`LSN` as a single 64-bit integer. ##ATTENTION##: If a wrong LSN value is specified, it is impossible to diagnose this, causing the backup to be unusable. Be careful!78 When creating an incremental backup, you can specify the log sequence number (:term:`LSN`) instead of specifying :option:`--incremental-basedir`. For databases created by *MySQL* and *Percona Server* 5.0-series versions, specify the :term:`LSN` as two 32-bit integers in high:low format. For databases created in 5.1 and later, specify the :term:`LSN` as a single 64-bit integer. ##ATTENTION##: If a wrong LSN value is specified (a user error which XtraBackup is unable to detect), the backup will be unusable. Be careful!
7979
80.. option:: --innodb-log-arch-dir80.. option:: --innodb-log-arch-dir=DIRECTORY
8181
82 This option is used to specify the directory containing the archived logs. It can only be used with the :option:`xtrabackup --prepare` option.82 This option is used to specify the directory containing the archived logs. It can only be used with the :option:`xtrabackup --prepare` option.
8383
@@ -113,7 +113,7 @@
113 --innodb-read-io-threads113 --innodb-read-io-threads
114 --innodb-write-io-threads114 --innodb-write-io-threads
115115
116.. option:: --log-copy-interval116.. option:: --log-copy-interval=#
117117
118 This option specifies time interval between checks done by log copying thread in milliseconds (default is 1 second).118 This option specifies time interval between checks done by log copying thread in milliseconds (default is 1 second).
119119
@@ -169,7 +169,7 @@
169169
170 A file containing one table name per line, in databasename.tablename format. The backup will be limited to the specified tables. See :ref:`scripting-xtrabackup`.170 A file containing one table name per line, in databasename.tablename format. The backup will be limited to the specified tables. See :ref:`scripting-xtrabackup`.
171171
172.. option:: --target-dir=name172.. option:: --target-dir=DIRECTORY
173173
174 This option specifies the destination directory for the backup. If the directory does not exist, :program:`xtrabackup` creates it. If the directory does exist and is empty, :program:`xtrabackup` will succeed. :program:`xtrabackup` will not overwrite existing files, however; it will fail with operating system error 17, ``file exists``.174 This option specifies the destination directory for the backup. If the directory does not exist, :program:`xtrabackup` creates it. If the directory does exist and is empty, :program:`xtrabackup` will succeed. :program:`xtrabackup` will not overwrite existing files, however; it will fail with operating system error 17, ``file exists``.
175175
@@ -183,13 +183,13 @@
183183
184 This option is currently not used for anything except printing out the correct tmpdir parameter when :option:`--print-param` is used.184 This option is currently not used for anything except printing out the correct tmpdir parameter when :option:`--print-param` is used.
185185
186.. option:: --to-archived-lsn186.. option:: --to-archived-lsn=LSN
187187
188 This option is used to specify the LSN to which the logs should be applied when backups are being prepared. It can only be used with the :option:`xtrabackup --prepare` option.188 This option is used to specify the LSN to which the logs should be applied when backups are being prepared. It can only be used with the :option:`xtrabackup --prepare` option.
189189
190.. option:: --use-memory=#190.. option:: --use-memory=#
191191
192 This option affects how much memory is allocated for preparing a backup with :option:`--prepare`, or analyzing statistics with :option:`--stats`. Its purpose is similar to :term:`innodb_buffer_pool_size`. It does not do the same thing as the similarly named option in Oracle's InnoDB Hot Backup tool. The default value is 100MB, and if you have enough available memory, 1GB to 2GB is a good recommended value.192 This option affects how much memory is allocated for preparing a backup with :option:`--prepare`, or analyzing statistics with :option:`--stats`. Its purpose is similar to :term:`innodb_buffer_pool_size`. It does not do the same thing as the similarly named option in Oracle's InnoDB Hot Backup tool. The default value is 100MB, and if you have enough available memory, 1GB to 2GB is a good recommended value. Multiples are supported providing the unit (e.g. 1MB, 1M, 1GB, 1G).
193193
194.. option:: --version194.. option:: --version
195195

Subscribers

People subscribed via source and target branches