参数说明:
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 |