[sysadmin-bin] Kill long running queries at the end of mariabackup



commit 8c232e30596d58f6fde32cca50d7cab4f6ce72b6
Author: Bartłomiej Piotrowski <bpiotrowski gnome org>
Date:   Fri Apr 29 08:57:04 2022 +0200

    Kill long running queries at the end of mariabackup

 mysqlbackup | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
---
diff --git a/mysqlbackup b/mysqlbackup
index f7d9c23..9c9e69d 100755
--- a/mysqlbackup
+++ b/mysqlbackup
@@ -3,7 +3,7 @@
 set -e
 
 DESTDIR=/mnt/galera-backups
-mariabackup="scl enable rh-mariadb103 -- mariabackup --user=root --backup --stream=xbstream 
--open-files-limit=20480"
+mariabackup="scl enable rh-mariadb103 -- mariabackup --user=root --backup --stream=xbstream 
--open-files-limit=20480 --ftwrl-wait-threshold=40 --ftwrl-wait-timeout=180 --kill-long-queries-timeout=30 
--galera-info"
 
 mysql -N -e 'show databases' | while read -r dbname; do
     ionice -c2 -n7 $mariabackup --databases="$dbname" | zstd -T6 -11 - > 
"$DESTDIR/${dbname}.xbstream.zst.tmp"


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]