MySQL Enterprise Backup User's Guide (Version 3.12.5)
For an overview on backup compression, see Section 4.3.3, “Making a Compressed Backup”.
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.
| 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.
| 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.
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 3.12.3 and later).