[sysadmin-bin] Kill long running queries at the end of mariabackup
- From: Bartłomiej Piotrowski <bpiotrowski src gnome org>
- To: gnome-sysadmin gnome org,commits-list gnome org
- Subject: [sysadmin-bin] Kill long running queries at the end of mariabackup
- Date: Fri, 29 Apr 2022 06:59:47 +0000 (UTC)
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]