xtrabackup-2.1.2-611安装(五)
DB tables (this includes the system
MyISAM tables in the mysql database), otherwise it could lead to an
inconsistent backup. If you are considering to use --no-lock because
your backups are failing to acquire the lock, this could be because
of incoming replication events preventing the lock from succeeding.
Please try using --safe-slave-backup to momentarily stop the
replication slave thread, this may help the backup to succeed and
you then don't need to resort to using this option.
--no-timestamp
This option prevents creation of a time-stamped subdirectory of the
BACKUP-ROOT-DIR given on the command line. When it is specified, the
backup is done in BACKUP-ROOT-DIR instead.
--parallel=NUMBER-OF-THREADS
This option specifies the number of threads the xtrabackup child
process should use to back up files concurrently. The option accepts
an integer argument. It is passed directly to xtrabackup's
--parallel option. See the xtrabackup documentation for details.
--password=WORD
This option specifies the password to use when connecting to the
database. It accepts a string argument. It is passed to the mysql
child process without alteration. See mysql --help for details.
--port=PORT
This option specifies the port to use when connecting to the
database server with TCP/IP. The option accepts a string argument.
It is passed to the mysql child process. It is passed to the mysql
child process without alteration. See mysql --help for details.
--rebuild-indexes
This option only has effect when used together with the --apply-log
option and is passed directly to xtrabackup. When used, makes
xtrabackup rebuild all secondary indexes after applying the log.
This option is normally used to prepare compact backups. See the
XtraBackup manual for more information.
--rebuild-threads
This option only has effect when used together with the --apply-log
and --rebuild-indexes option and is passed directly to xtrabackup.
When used, xtrabackup processes tablespaces in parallel with the
specified number of threads when rebuilding indexes. See the
XtraBackup manual for more information.
--redo-only
This option should be used when preparing the base full backup and
when merging all incrementals except the last one. This option is
passed directly to xtrabackup's --apply-log-only option. This forces
xtrabackup to skip the "rollback" phase and do a "redo" only. This
is necessary if the backup will have incremental changes applied to
it later. See the xtrabackup documentation for details.
--rsync
Uses the rsync utility to optimize local file transfers. When this
option is specified, innobackupex uses rsync to copy all non-InnoDB
files instead of spawning a separate cp for each file, which can be
much faster for servers with a large number of databases or tables.
This option cannot be used together with --stream.
--safe-slave-backup
Stop slave SQL thread and wait to start backup until
Slave_open_temp_tables in "SHOW STATUS" is zero. If there are no
open temporary tables, the backup will take place, otherwise the SQL