Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1734268
  • 博文数量: 107
  • 博客积分: 1715
  • 博客等级: 上尉
  • 技术积分: 3168
  • 用 户 组: 普通用户
  • 注册时间: 2012-04-18 18:42
个人简介

阿里巴巴DBA,原去哪儿网DBA。专注于MySQL源码研究、DBA运维、CGroup虚拟化及Linux Kernel源码研究等。 github:https://github.com/HengWang/ Email:king_wangheng@163.com 微博 :@王恒-Henry QQ :506437736

文章分类

全部博文(107)

文章存档

2014年(2)

2013年(38)

2012年(67)

分类: 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

 

阅读(4445) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~