This is why you don't use Influx. This is necessary, because otherwise DB crashes.

influx-export.sh

#!/usr/bin/env bash
set -o pipefail
#set -x

days=${1:-7}
mins=`expr ${days} '*' 24 '*' 60`
interval=1440
now=`date +%s%N`
db='noc_171212'
d=/tti/noc/export/"${now}"

mkdir -p "${d}"

echo "Creating export at:" 1>&2
echo "${d}"
for table in 'gateway_status' 'gateway_uplink' 'gateway_downlink' 'broker_uplink' 'broker_downlink' 'handler_uplink' 'handler_downlink'; do
  path="${d}/${table}.csv"
  echo "Extracting data from ${db}.${table} to ${path}" 1>&2
  for i in `seq $(expr ${mins} '/' ${interval})`; do
    while : ; do
      if [ $i == 1 ]; then
        echo "From ${interval}m ago" 1>&2
        ( influx -format 'csv' -database "${db}" -execute "select * from ${table} where time >= ${now} - ${interval}m" || { echo ""; exit 1; } ) > "$path"
      else
        echo "From `expr ${i} '*' ${interval}` m ago to `expr ${interval} '*' '(' ${i} '-' 1 ')'`m ago" 1>&2
        ( influx -format 'csv' -database "${db}" -execute "select * from ${table} where time >= ${now} - `expr ${interval} '*' ${i}`m and time < ${now} - `expr ${interval} '*' '(' ${i} '-' 1 ')'`m" || { echo ""; exit 1; } ) | sed '1d' >> "$path"
      fi

      if [ $? == 0 ] ; then
        break
      fi

      echo "Repeating in 5 sec..." 1>&2
      sleep 5
    done
  done
done