xtrabackup参数说明
来源:互联网 发布:terminator ubuntu 编辑:程序博客网 时间:2024/05/27 00:48
参数说明:
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
- xtrabackup参数说明
- xtrabackup备份说明
- xtrabackup新版详细说明
- Xtrabackup 简介及备份原理说明
- mysqldump和xtrabackup备份原理实现说明
- xtrabackup新版详细说明(version-2.4.1)
- XtraBackup应用说明(支持TokuDB)
- XtraBackup
- XtraBackup
- xtrabackup
- xtrabackup
- XtraBackup
- Xtrabackup热备过程中需要注意的参数
- GHOST参数详细说明
- jdbc url参数说明
- Tomcat 启动参数说明。
- oracle参数说明
- document.execComand()参数说明
- ssdp协议介绍
- 删除linux出现GRUB,装完windowsxp 出现GRUB
- oracle的char类型对空格的怪异处理
- 何为三国!!
- 用EventHandler在列表中创建启动工作流栏
- xtrabackup参数说明
- innobackupex参数说明
- android 幕滑动效果
- myeclipse设置tomcat内存大小
- memcached 工作原理
- [转载]iPhone开发的一些小技巧
- js数组的操作
- 并不包含调试信息(未加载任何符号)
- 判断频率最高字符出现次数