netdata.conf for db size on a Docker container?

Help
, ,
1

Problem/Question

My database is growing in size, Id like to keep it small.
How do I best do this on my Docker install? Edit what conf file, do another volume mount within Docker?

Relevant docs you followed/actions you took to solve the issue

I have read

So the default for 3 tiers is 3 GB size? Id like to size down, just keep a DB history for one or maybe two weeks.

Environment/Browser/Agent’s version etc

Docker container from hub.docker.com
netdata/netdata:latest
running on a Raspberry Pi 5

What I expected to happen

Have my netdata install resize its DB tiers, so daily backups will shrink in size, too

Thank you!

2

Hi. Could you please elaborate on the specific issue you’re encountering? It is very straightforward.

3

Sure / sorry.
On my Docker install, I have a volume mount for /etc/netdata.
Within this directory, there is a file called netdata.conf :

# netdata can generate its own config which is available at 'http://<IP>:19999/netdata.conf'
# You can download it using:
#    curl -o //etc/netdata/netdata.conf http://localhost:19999/netdata.conf
# or
#    wget -O //etc/netdata/netdata.conf http://localhost:19999/netdata.conf

= it’s an empty file. Is this the right file to alter the storage tiers?
Will one setting in this file do the trick for me?
I.e.


[db]
    mode = dbengine
    storage tiers = **2**

    # Tier 0, per second data. Set to 0 for no limit.
    dbengine tier 0 retention size = 1GiB
    dbengine tier 0 retention time = **7d**

    # Tier 1, per minute data. Set to 0 for no limit.
    dbengine tier 1 retention size = 1GiB
    dbengine tier 1 retention time = **14d**

    # Tier 2, per hour data. Set to 0 for no limit.
    #dbengine tier 2 retention size = 1GiB
    #dbengine tier 2 retention time = 2y

Thanks for helping, @ilyam8

4

Is this the right file to alter the storage tiers?

Yes. But your syntax is wrong. Why did you add ** for time retention values? If you need only time-based (e.g. 1 week):

[db]
    mode = dbengine
    storage tiers = 1

    # Tier 0, per second data. Set to 0 for no limit.
    dbengine tier 0 retention size = 0
    dbengine tier 0 retention time = 7d

Just read the retention settings for details.

5

sorry, the ** were added by the forum software because I marked it as bold

I will try it like that now. I was confused before, because my .conf file will have this setting only, nothing else. I was expecting to modify a .conf file with lots more in it.