Pass --kill-wait-query-type as general option to xtrabackup for --test_mode configs

[ShahriyarR]

Full options to pass to xtrabackup:

--kill-wait-query-type=all --kill-long-queries-timeout=900 --kill-long-query-type=all

According to: https://bugs.launchpad.net/percona-xtrabackup/+bug/1736177

It may cause the segfault

[ShahriyarR]

So according to the doc: https://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/improved_ftwrl.html

I need non-Innodb table with long running queries, so sleep() queries will not help here.

[ShahriyarR]

• Alter some of the tables from innodb to myisam
• run select on this; maybe something like -> select benchmark(99999, md5(c)) from sbtest26;

[ShahriyarR]

Now it is working. The combination of those options: --ftwrl-wait-timeout=0 --ftwrl-wait-query-type=all --ftwrl-wait-threshold=1 --kill-wait-query-type=all --kill-long-query-type=all --kill-long-queries-timeout=1

In order to force Xtrabackup to use FTWRL and not Backup Locks, you should pass --no-backup-locks option as well.