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 the                      xtrabackup_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