mysql xtrabackup 参数_xtrabackup参数说明

The following options may be given as the

first argument

--print-defaults

Print the program argument list and exit.

--no-defaults

Don't read default options from any

option file.

--defaults-file=#

Only read default options from the given

file #.

--defaults-extra-file=#

Read this file after the global files are

read.

-v, --version

print xtrabackup version information

--target-dir=name

destination directory

--backup

take backup to target-dir

--stats

calc statistic of datadir (offline mysqld

is recommended)

--prepare

prepare a backup for starting mysql

server on the backup.

--export

create files to import to another

database when prepare.

--apply-log-only

stop recovery process not to progress LSN

after applying log when prepare.

--print-param

print parameter of mysqld needed for

copyback.

--use-memory=#

The value is used instead of

buffer_pool_size

--suspend-at-end

creates a file 'xtrabackup_suspended' and

waits until the user deletes that file at the end of '--backup'

--throttle=#

limit count of IO operations (pairs of

read&write) per second to IOS values (for '--backup')

--log-stream

outputs the contents of

'xtrabackup_logfile' to stdout only until the file 'xtrabackup_suspended'

deleted (for'--backup').

--extra-lsndir=name

(for --backup)save an extra copy of

thextrabackup_checkpoints file in this directory.

--incremental-lsn=name

(for --backup): copy only .ibd pages

newer than specified LSN 'high:low'. ##ATTENTION##: If a wrong LSN value is specified,

it is impossible to diagnose this, causing the backup to be unusable. Be

careful!

--incremental-basedir=name

(for --backup): copy only .ibd pages

newer than backup at specified directory.

--incremental-dir=name

(for --prepare): apply .delta files and

logfile in the specified directory.

--tables=name

filtering by regexp for table names.

--tables-file=name

filtering by list of the exact

database.table name in the file.

--create-ib-logfile **

not work for now** creates ib_logfile*

also after '--prepare'. ### If you want create ib_logfile*, only re-execute

this command in same options. ###

-h, --datadir=name

Path to the database root.

-t, --tmpdir=name

Path for temporary files. Several paths

may be specified, separated by a colon (:), in this case they are used in a round-robin

fashion.

--parallel=#

Number of threads to use for parallel

datafiles transfer. Does not have any effect in the stream mode. The default value

is 1.

--stream=name

Stream all backup files to the standard

output in the specified format. Currently the only supported format is 'tar'.

--compress[=name]

Compress individual backup files using

the specified compression algorithm. Currently the only supported algorithm

is 'quicklz'. It is also the default algorithm, i.e. the one used when

--compress is used without an argument.

--compress-threads=#

Number of threads for parallel data

compression. The default value is 1.

--innodb-adaptive-hash-index

Enable InnoDB adaptive hash index

(enabled by default). Disable with --skip-innodb-adaptive-hash-index. (Defaults

to on; use --skip-innodb-adaptive-hash-index to disable.)

--innodb-additional-mem-pool-size=#

Size of a memory pool InnoDB uses to

store data dictionary information and other internal data structures.

--innodb-autoextend-increment=#

Data file autoextend increment in

megabytes

--innodb-buffer-pool-size=#

The size of the memory buffer InnoDB uses

to cache data and indexes of its tables.

--innodb-checksums

Enable InnoDB checksums validation

(enabled by default). Disable with --skip-innodb-checksums. (Defaults to on;

use --skip-innodb-checksums to disable.)

--innodb-data-file-path=name

Path to individual files and their sizes.

--innodb-data-home-dir=name

The common part for InnoDB table spaces.

--innodb-doublewrite

Enable InnoDB doublewrite buffer (enabled

by default). Disable with --skip-innodb-doublewrite. (Defaults to on; use

--skip-innodb-doublewrite to disable.)

--innodb-io-capacity[=#]

Number of IOPs the server can do. Tunes

the background IO rate

--innodb-file-io-threads=#

Number of file I/O threads in InnoDB.

--innodb-read-io-threads=#

Number of background read I/O threads in

InnoDB.

--innodb-write-io-threads=#

Number of background write I/O threads in

InnoDB.

--innodb-file-per-table

Stores each InnoDB table to an .ibd file

in the database dir.

--innodb-flush-log-at-trx-commit[=#]

Set to 0 (write and flush once per

second), 1 (write and flush at each commit) or 2 (write at commit, flush once

per second).

--innodb-flush-method=name

With which method to flush data.

--innodb-force-recovery=#

Helps to save your data in case the disk

image of the database becomes corrupt.

--innodb-lock-wait-timeout=#

Timeout in seconds an InnoDB transaction

may wait for a lock before being rolled back.

--innodb-log-buffer-size=#

The size of the buffer which InnoDB uses

to write log to the log files on disk.

--innodb-log-file-size=#

Size of each log file in a log group.

--innodb-log-files-in-group=#

Number of log files in the log group.

InnoDB writes to the files in a circular fashion. Value 3 is recommended here.

--innodb-log-group-home-dir=name

Path to InnoDB log files.

--innodb-max-dirty-pages-pct=#

Percentage of dirty pages allowed in

bufferpool.

--innodb-open-files=#

How many files at the maximum InnoDB

keeps open at the same time.

--debug-sync=name

Debug sync point. This is only used by

the xtrabackup test suite