09.04.2018

Reduce disk space usage by InfluxDB

InfluxDB can consume significant amount of disk space  if you have big number of hosts in your network. To reduce disk space consumption you can disable per host counters and keep only total counters and per subnet counters.

As first step, disable them in FastNetMon’s configuration:

sudo fcli set main influxdb_skip_host_counters enable
sudo fcli commit

Then, you need to clean up old tables.

Open InfluxDB command line client:

influx

Open FastNetMon’s table:

use fastnetmon

Check available data series:

show series;
key
---
hosts_traffic,host=xx
hosts_traffic,host=xx
hosts_traffic,host=xx
hosts_traffic,host=xx
hosts_traffic,host=xx
hosts_traffic,host=xx
hosts_traffic,host=xx
networks_traffic,network=xx/24
total_traffic,direction=other

Delete all records from hosts_traffic:

delete from hosts_traffic

Also, you can remove some old records only:

delete from hosts_traffic where time > 1000s;