阿里巴巴DBA,原去哪儿网DBA。专注于MySQL源码研究、DBA运维、CGroup虚拟化及Linux Kernel源码研究等。 github:https://github.com/HengWang/ Email:king_wangheng@163.com 微博 :@王恒-Henry QQ :506437736
分类: Mysql/postgreSQL
2012-06-21 18:07:27
参数说明:
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 |