Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save HariSekhon/5adbd1d3edf052737830720dc4577d36 to your computer and use it in GitHub Desktop.
Save HariSekhon/5adbd1d3edf052737830720dc4577d36 to your computer and use it in GitHub Desktop.
Delete old data from OpenTSDB using `scan --delete`
#!/bin/bash
set -o nounset
set -o errexit
set -o pipefail
TSDB_CMD=$( /usr/bin/which tsdb )
START_TIME="1y-ago"
END_TIME="21d-ago"
SLEEP=10
METRICS=$( /usr/bin/tsdb uid grep . | grep -a ^metrics | awk '{print $2}' | sed 's/\:$//g' )
for METRIC in ${METRICS}; do
CMD="${TSDB_CMD} scan --delete ${START_TIME} ${END_TIME} sum ${METRIC}"
echo "RUNNING: ${CMD}"
${CMD} > /dev/null
sleep ${SLEEP}
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment