MySQL Enterprise Backup User's Guide (Version 4.0.3)
For an overview on backup compression, see Section 4.3.4, “Making a Compressed Backup”.
--compress
Create backup in compressed format. For a regular backup,
among all the storage engines supported by MySQL, only data
files of the InnoDB format are compressed, and they bear the
.ibz
extension after the compression.
Similarly, for a single-image backup, only data files of the
InnoDB format inside the backup image are compressed. The
binary log and relay log files are compressed and saved with
the .bz
extension when being included
in a compressed backup.
Default: compression is disabled.
--compress-method
=ALGORITHM
Command-Line Format | --compress-method=ALGORITHM |
---|---|
Type | Enumeration |
Default Value | lz4 |
Valid Values |
|
Specifies the compression algorithm. The supported arguments for the option and the algorithms they represent are:
lz4
: LZ4 r109. Out of the three
algorithms that are supported, this is the most
efficient one, typically taking the shortest backup
and restore times with the lowest CPU cost. See
lz4—Extremely Fast Compression algorithm
for more details, including a comparison with other
compression algorithms.
lzma
: LZMA 9.20. Out of the three
supported algorithms, this typically provides the
highest compression ratio; but it is also far more
expensive in terms of CPU cost than the other two
options. Thus we do not recommend this for active
systems, but only for off-hour or inactive databases,
or where I/O rates are extremely low.
zlib
: ZLIB v1.2.3. This is in
between the other two supported algorithms in terms of
both speed and compression ratio. ZLIB was the only
compression algorithm available for MySQL Enterprise Backup versions
prior to 3.10.
Default: lz4. Explicitly specifying a value for the option
through a configuration file or command line automatically
enables the --compress
option.
--compress-level
=LEVEL
Command-Line Format | --compress-level=LEVEL |
---|---|
Type | Numeric |
Default Value | 1 |
Minimum Value | 0 |
Maximum Value | 9 |
Specifies the level of compression, ranging from
“0” to “9”: “0
”disables compression; “1” is fastest
compression, and “9” is highest (and slowest)
compression. The option is only meaningful for compression
using the ZLIB or LZMA algorithm; it is ignored when any
other algorithms are selected by the
--compress-method
option.
Default: 1 (lowest and fastest compression). Explicitly
specifying a non-zero value through a configuration file or
command line automatically enables the
--compress
option.
--uncompress
When used with the apply-log
or
copy-back-and-apply-log
operation, uncompresses a compressed backup before applying
the InnoDB log. When used with the
copy-back
operation,
uncompresses a compressed
prepared backup
(created by the
backup-and-apply-log
command with the --compress
option) before restoring it to a server (only supported for
MySQL Enterprise Backup 4.0.1 and later).