From b2d8186f883d9e02e370c32d666b33a9d3ef23a1 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 1 Sep 2016 14:22:03 -0700 Subject: [PATCH] JBAS-1554 C/O history deployment script mods Signed-off-by: Bill Erickson --- KCLS/sql/schema/tools/migrate-patron-co-history.sh | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) diff --git a/KCLS/sql/schema/tools/migrate-patron-co-history.sh b/KCLS/sql/schema/tools/migrate-patron-co-history.sh index b9c32bb1e7..5201219fb3 100755 --- a/KCLS/sql/schema/tools/migrate-patron-co-history.sh +++ b/KCLS/sql/schema/tools/migrate-patron-co-history.sh @@ -1,13 +1,19 @@ #!/bin/bash set -eu -LIMIT=5000 -PAUSE=30 +# 500 users per batch ~= 100k history rows per batch +LIMIT=500 +ITERS=601 OFFSET=0 +PAUSE=10 PSQL="psql -U evergreen" -for SLOT in $(seq 0 62); do +for SLOT in $(seq 0 $ITERS); do + echo "Starting with history count: " + echo "SELECT COUNT(*) FROM action.usr_circ_history" | $PSQL + echo "" echo "Starting OFFSET=$OFFSET at $(date +'%F %T')" - echo "SELECT action.migrate_usr_circ_history($LIMIT, $OFFSET)" | $PSQL + echo "SET STATEMENT_TIMEOUT = 0; SELECT action.migrate_usr_circ_history($LIMIT, $OFFSET)" | $PSQL + echo "" echo "Finished OFFSET=$OFFSET at $(date +'%F %T')" echo "Pausing $PAUSE seconds before next iteration" sleep $PAUSE -- 2.11.0