Merge lp:~hrvojem/percona-xtrabackup/bug1264622-2.2 into lp:percona-xtrabackup/2.2
- bug1264622-2.2
- Merge into 2.2
Proposed by
Hrvoje Matijakovic
Status: | Merged |
---|---|
Approved by: | Alexey Kopytov |
Approved revision: | no longer in the source branch. |
Merged at revision: | 4978 |
Proposed branch: | lp:~hrvojem/percona-xtrabackup/bug1264622-2.2 |
Merge into: | lp:percona-xtrabackup/2.2 |
Diff against target: |
216 lines (+29/-31) 4 files modified
storage/innobase/xtrabackup/doc/source/conf.py (+0/-2) storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_option_reference.rst (+9/-9) storage/innobase/xtrabackup/doc/source/intro.rst (+2/-2) storage/innobase/xtrabackup/doc/source/xtrabackup_bin/xbk_option_reference.rst (+18/-18) |
To merge this branch: | bzr merge lp:~hrvojem/percona-xtrabackup/bug1264622-2.2 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Alexey Kopytov (community) | Approve | ||
Review via email: mp+221991@code.launchpad.net |
Commit message
Description of the change
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
1 | === modified file 'storage/innobase/xtrabackup/doc/source/conf.py' | |||
2 | --- storage/innobase/xtrabackup/doc/source/conf.py 2014-05-06 17:08:06 +0000 | |||
3 | +++ storage/innobase/xtrabackup/doc/source/conf.py 2014-06-04 08:15:57 +0000 | |||
4 | @@ -118,8 +118,6 @@ | |||
5 | 118 | 118 | ||
6 | 119 | .. |MySQL| replace:: *MySQL* | 119 | .. |MySQL| replace:: *MySQL* |
7 | 120 | 120 | ||
8 | 121 | .. |Drizzle| replace:: *Drizzle* | ||
9 | 122 | |||
10 | 123 | .. |MariaDB| replace:: *MariaDB* | 121 | .. |MariaDB| replace:: *MariaDB* |
11 | 124 | 122 | ||
12 | 125 | .. |tar4ibd| replace:: :program:`tar4ibd` | 123 | .. |tar4ibd| replace:: :program:`tar4ibd` |
13 | 126 | 124 | ||
14 | === modified file 'storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_option_reference.rst' | |||
15 | --- storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_option_reference.rst 2014-03-28 11:46:09 +0000 | |||
16 | +++ storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_option_reference.rst 2014-06-04 08:15:57 +0000 | |||
17 | @@ -22,11 +22,11 @@ | |||
18 | 22 | 22 | ||
19 | 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. |
20 | 24 | 24 | ||
22 | 25 | .. option:: --compress-threads | 25 | .. option:: --compress-threads=# |
23 | 26 | 26 | ||
24 | 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. |
25 | 28 | 28 | ||
27 | 29 | .. option:: --compress-chunk-size | 29 | .. option:: --compress-chunk-size=# |
28 | 30 | 30 | ||
29 | 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. |
30 | 32 | 32 | ||
31 | @@ -70,11 +70,11 @@ | |||
32 | 70 | 70 | ||
33 | 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. |
34 | 72 | 72 | ||
36 | 73 | .. option:: --encrypt-threads | 73 | .. option:: --encrypt-threads=# |
37 | 74 | 74 | ||
38 | 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. |
39 | 76 | 76 | ||
41 | 77 | .. option:: --encrypt-chunk-size | 77 | .. option:: --encrypt-chunk-size=# |
42 | 78 | 78 | ||
43 | 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. |
44 | 80 | 80 | ||
45 | @@ -134,7 +134,7 @@ | |||
46 | 134 | 134 | ||
47 | 135 | This option specifies the UUID of the specific history record stored in the :ref:`PERCONA_SCHEMA.xtrabackup_history <xtrabackup_history>` to base an incremental backup on. :option:`innobackupex --incremental-history-name`,:optionL`innobackupex --incremental-basedir` and :option:`innobackupex --incremental-lsn`. If no valid lsn can be found (no success record with that uuid) xtrabackup will return with an error. It is used with the :option:`innobackupex --incremental` option. | 135 | This option specifies the UUID of the specific history record stored in the :ref:`PERCONA_SCHEMA.xtrabackup_history <xtrabackup_history>` to base an incremental backup on. :option:`innobackupex --incremental-history-name`,:optionL`innobackupex --incremental-basedir` and :option:`innobackupex --incremental-lsn`. If no valid lsn can be found (no success record with that uuid) xtrabackup will return with an error. It is used with the :option:`innobackupex --incremental` option. |
48 | 136 | 136 | ||
50 | 137 | .. option:: --incremental-lsn | 137 | .. option:: --incremental-lsn=LSN |
51 | 138 | 138 | ||
52 | 139 | 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. | 139 | 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. |
53 | 140 | 140 | ||
54 | @@ -158,7 +158,7 @@ | |||
55 | 158 | 158 | ||
56 | 159 | This option specifies which types of queries are allowed to complete before innobackupex will issue the global lock. Default is all. | 159 | This option specifies which types of queries are allowed to complete before innobackupex will issue the global lock. Default is all. |
57 | 160 | 160 | ||
59 | 161 | .. option:: --log-copy-interval | 161 | .. option:: --log-copy-interval=# |
60 | 162 | 162 | ||
61 | 163 | This option specifies time interval between checks done by log copying thread in milliseconds. | 163 | This option specifies time interval between checks done by log copying thread in milliseconds. |
62 | 164 | 164 | ||
63 | @@ -211,7 +211,7 @@ | |||
64 | 211 | 211 | ||
65 | 212 | 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. | 212 | 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. |
66 | 213 | 213 | ||
68 | 214 | .. option:: --safe-slave-backup-timeout | 214 | .. option:: --safe-slave-backup-timeout=SECONDS |
69 | 215 | 215 | ||
70 | 216 | How many seconds :option:`--safe-slave-backup`` should wait for ``Slave_open_temp_tables`` to become zero. Defaults to 300 seconds. | 216 | How many seconds :option:`--safe-slave-backup`` should wait for ``Slave_open_temp_tables`` to become zero. Defaults to 300 seconds. |
71 | 217 | 217 | ||
72 | @@ -227,7 +227,7 @@ | |||
73 | 227 | 227 | ||
74 | 228 | 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. | 228 | 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. |
75 | 229 | 229 | ||
77 | 230 | .. option:: --sshopt = SSH-OPTIONS | 230 | .. option:: --sshopt=SSH-OPTIONS |
78 | 231 | 231 | ||
79 | 232 | 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. | 232 | 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. |
80 | 233 | 233 | ||
81 | @@ -247,7 +247,7 @@ | |||
82 | 247 | 247 | ||
83 | 248 | 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. | 248 | 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. |
84 | 249 | 249 | ||
86 | 250 | .. option:: --use-memory | 250 | .. option:: --use-memory=# |
87 | 251 | 251 | ||
88 | 252 | 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. | 252 | 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. |
89 | 253 | 253 | ||
90 | 254 | 254 | ||
91 | === modified file 'storage/innobase/xtrabackup/doc/source/intro.rst' | |||
92 | --- storage/innobase/xtrabackup/doc/source/intro.rst 2014-05-18 17:31:38 +0000 | |||
93 | +++ storage/innobase/xtrabackup/doc/source/intro.rst 2014-06-04 08:15:57 +0000 | |||
94 | @@ -15,9 +15,9 @@ | |||
95 | 15 | 15 | ||
96 | 16 | * Higher uptime due to faster restore time | 16 | * Higher uptime due to faster restore time |
97 | 17 | 17 | ||
99 | 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. |
100 | 19 | 19 | ||
102 | 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. |
103 | 21 | 21 | ||
104 | 22 | Percona'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. | 22 | Percona'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. |
105 | 23 | 23 | ||
106 | 24 | 24 | ||
107 | === modified file 'storage/innobase/xtrabackup/doc/source/xtrabackup_bin/xbk_option_reference.rst' | |||
108 | --- storage/innobase/xtrabackup/doc/source/xtrabackup_bin/xbk_option_reference.rst 2013-11-15 12:42:15 +0000 | |||
109 | +++ storage/innobase/xtrabackup/doc/source/xtrabackup_bin/xbk_option_reference.rst 2014-06-04 08:15:57 +0000 | |||
110 | @@ -25,11 +25,11 @@ | |||
111 | 25 | 25 | ||
112 | 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. |
113 | 27 | 27 | ||
115 | 28 | .. option:: --compress-chunk-size | 28 | .. option:: --compress-chunk-size=# |
116 | 29 | 29 | ||
117 | 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. |
118 | 31 | 31 | ||
120 | 32 | .. option:: --compress-threads | 32 | .. option:: --compress-threads=# |
121 | 33 | 33 | ||
122 | 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. |
123 | 35 | 35 | ||
124 | @@ -37,19 +37,19 @@ | |||
125 | 37 | 37 | ||
126 | 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. |
127 | 39 | 39 | ||
129 | 40 | .. option:: --datadir | 40 | .. option:: --datadir=DIRECTORY |
130 | 41 | 41 | ||
131 | 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. |
132 | 43 | 43 | ||
134 | 44 | .. option:: --defaults-extra-file=# | 44 | .. option:: --defaults-extra-file=[MY.CNF] |
135 | 45 | 45 | ||
136 | 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. |
137 | 47 | 47 | ||
139 | 48 | .. option:: --defaults-file=# | 48 | .. option:: --defaults-file=[MY.CNF] |
140 | 49 | 49 | ||
141 | 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. |
142 | 51 | 51 | ||
144 | 52 | .. option:: --defaults-group | 52 | .. option:: --defaults-group=GROUP-NAME |
145 | 53 | 53 | ||
146 | 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. |
147 | 55 | 55 | ||
148 | @@ -57,15 +57,15 @@ | |||
149 | 57 | 57 | ||
150 | 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>`. |
151 | 59 | 59 | ||
153 | 60 | .. option:: --extra-lsndir=name | 60 | .. option:: --extra-lsndir=DIRECTORY |
154 | 61 | 61 | ||
155 | 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. |
156 | 63 | 63 | ||
158 | 64 | .. option:: --incremental-basedir | 64 | .. option:: --incremental-basedir=DIRECTORY |
159 | 65 | 65 | ||
160 | 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. |
161 | 67 | 67 | ||
163 | 68 | .. option:: --incremental-dir | 68 | .. option:: --incremental-dir=DIRECTORY |
164 | 69 | 69 | ||
165 | 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. |
166 | 71 | 71 | ||
167 | @@ -73,11 +73,11 @@ | |||
168 | 73 | 73 | ||
169 | 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. |
170 | 75 | 75 | ||
176 | 76 | .. option:: --incremental-lsn=name | 76 | .. option:: --incremental-lsn=LSN |
177 | 77 | 77 | ||
178 | 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! |
179 | 79 | 79 | ||
180 | 80 | .. option:: --innodb-log-arch-dir | 80 | .. option:: --innodb-log-arch-dir=DIRECTORY |
181 | 81 | 81 | ||
182 | 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. |
183 | 83 | 83 | ||
184 | @@ -113,7 +113,7 @@ | |||
185 | 113 | --innodb-read-io-threads | 113 | --innodb-read-io-threads |
186 | 114 | --innodb-write-io-threads | 114 | --innodb-write-io-threads |
187 | 115 | 115 | ||
189 | 116 | .. option:: --log-copy-interval | 116 | .. option:: --log-copy-interval=# |
190 | 117 | 117 | ||
191 | 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). |
192 | 119 | 119 | ||
193 | @@ -169,7 +169,7 @@ | |||
194 | 169 | 169 | ||
195 | 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`. |
196 | 171 | 171 | ||
198 | 172 | .. option:: --target-dir=name | 172 | .. option:: --target-dir=DIRECTORY |
199 | 173 | 173 | ||
200 | 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``. |
201 | 175 | 175 | ||
202 | @@ -183,13 +183,13 @@ | |||
203 | 183 | 183 | ||
204 | 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. |
205 | 185 | 185 | ||
207 | 186 | .. option:: --to-archived-lsn | 186 | .. option:: --to-archived-lsn=LSN |
208 | 187 | 187 | ||
209 | 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. |
210 | 189 | 189 | ||
211 | 190 | .. option:: --use-memory=# | 190 | .. option:: --use-memory=# |
212 | 191 | 191 | ||
214 | 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). |
215 | 193 | 193 | ||
216 | 194 | .. option:: --version | 194 | .. option:: --version |
217 | 195 | 195 |