xtrabackup相关参数

9.3.3.参数1
9.3.3.1.–ftwrl-wait-query-type
什么类型的SQL需等待，一般是all或者update
9.3.3.2.–ftwrl-wait-threshold
在执行ftwrl之前，等待正在运行SQL时间
9.3.3.3.–ftwrl-wait-timeout
等待一段时间(-ftwrl-wait-timeout 没有执行的SQL）执行ftwrl(flush tables with read lock)，,如果等待超时就会放弃备份并报错，默认0是关闭，不等待
9.3.3.4.–kill-long-queries-timeout
执行ftwrl时，等待一个SQL多长运行时间（kill-long-queries-timeout ），超过就Kill这类SQL ,默认0不Kill
9.3.3.5.–kill-long-query-type
什么类型的SQL可以被kill

Example
Running the xtrabackup with the following options will cause xtrabackup to spend no longer than 3 minutes
waiting for all queries older than 40 seconds to complete.
$ xtrabackup --backup --ftwrl-wait-threshold=40 \
--ftwrl-wait-query-type=all --ftwrl-wait-timeout=180 \
--kill-long-queries-timeout=20 --kill-long-query-type=all \
--target-dir=/data/backups/
After FLUSH TABLES WITH READ LOCK is issued, xtrabackup 
1
2
3
4
5
6
7