[Spce-user] influx DB tsm file growth

Matthew Ogden matthew at tenacit.net
Thu Aug 22 02:36:35 EDT 2019


Hi

I see there is a template file for it in
:  /etc/ngcp-config/templates/etc/influxdb/influxdb.conf.tt2

There is a retention section, with no settings set.  Is there somewhere
else this data is being stored?

In the end, I used influx command line. then ran > ALTER RETENTION POLICY
"autogen" on "telegraf" duration 48w

since the duration was set to zero, it was I guess, infinitely growing.

Kind Regards
ᐧ

On Wed, 21 Aug 2019 at 08:25, Matthew Ogden <matthew at tenacit.net> wrote:

> Hi All
>
> Any pointers useful, approaching critical space now.
>
> Kind Regards
>>
> On Mon, 19 Aug 2019 at 09:03, Matthew Ogden <matthew at tenacit.net> wrote:
>
>> Hi All
>>
>> Is there some settting or something that we have perhaps missed, it seems
>> like these tsm of  telegraf are growing a fair amount and no pruning
>> process is taking the files away.
>>
>> Kind Regards
>>
>>  793328  60224 -rw-r--r--   1 influxdb influxdb 61661327 Aug 19 06:10 /ngcp-data/influxdb/data/telegraf/autogen/322/000000036-000000002.tsm
>>
>>    794429  59640 -rw-r--r--   1 influxdb influxdb 61065284 Aug  5 06:10 /ngcp-data/influxdb/data/telegraf/autogen/304/000000036-000000002.tsm
>>
>>    793374  59468 -rw-r--r--   1 influxdb influxdb 60890593 Aug 12 06:10 /ngcp-data/influxdb/data/telegraf/autogen/313/000000036-000000002.tsm
>>
>>    789992  59384 -rw-r--r--   1 influxdb influxdb 60802165 Jul 29 06:10 /ngcp-data/influxdb/data/telegraf/autogen/295/000000036-000000002.tsm
>>
>>    787918  59160 -rw-r--r--   1 influxdb influxdb 60572934 Jul 22 06:10 /ngcp-data/influxdb/data/telegraf/autogen/286/000000036-000000002.tsm
>>
>>    794303  58592 -rw-r--r--   1 influxdb influxdb 59992487 Jul  8 06:10 /ngcp-data/influxdb/data/telegraf/autogen/268/000000036-000000002.tsm
>>
>>    798512  58564 -rw-r--r--   1 influxdb influxdb 59965140 Jul 15 06:10 /ngcp-data/influxdb/data/telegraf/autogen/277/000000036-000000002.tsm
>>
>>    793233  58380 -rw-r--r--   1 influxdb influxdb 59774140 Jul  1 06:10 /ngcp-data/influxdb/data/telegraf/autogen/259/000000036-000000002.tsm
>>
>>    788567  57372 -rw-r--r--   1 influxdb influxdb 58743456 Jun 24 06:10 /ngcp-data/influxdb/data/telegraf/autogen/250/000000036-000000002.tsm
>>
>>    794588  54296 -rw-r--r--   1 influxdb influxdb 55599040 May 20 06:10 /ngcp-data/influxdb/data/telegraf/autogen/221/000000035-000000002.tsm
>>
>>    787778  53900 -rw-r--r--   1 influxdb influxdb 55185637 May  6 06:10 /ngcp-data/influxdb/data/telegraf/autogen/203/000000036-000000002.tsm
>>
>>      3575  53800 -rw-r--r--   1 influxdb influxdb 55088466 Apr 15 06:10 /ngcp-data/influxdb/data/telegraf/autogen/176/000000037-000000002.tsm
>>
>>    786493  52980 -rw-r--r--   1 influxdb influxdb 54246236 May 13 06:10 /ngcp-data/influxdb/data/telegraf/autogen/212/000000036-000000002.tsm
>>
>>    797159  52904 -rw-r--r--   1 influxdb influxdb 54170151 Apr 29 06:10 /ngcp-data/influxdb/data/telegraf/autogen/194/000000035-000000002.tsm
>>
>>    796987  52544 -rw-r--r--   1 influxdb influxdb 53802813 Apr 22 06:10 /ngcp-data/influxdb/data/telegraf/autogen/185/000000035-000000002.tsm
>>
>>    806256  52448 -rw-r--r--   1 influxdb influxdb 53705378 Mar 11 06:10 /ngcp-data/influxdb/data/telegraf/autogen/134/000000035-000000002.tsm
>>
>>      1611  52316 -rw-r--r--   1 influxdb influxdb 53563782 Apr  1 06:10 /ngcp-data/influxdb/data/telegraf/autogen/161/000000036-000000002.tsm
>>
>>    805656  52304 -rw-r--r--   1 influxdb influxdb 53558585 Mar  4 06:10 /ngcp-data/influxdb/data/telegraf/autogen/125/000000035-000000002.tsm
>>
>>    802480  52120 -rw-r--r--   1 influxdb influxdb 53367188 Feb 25 06:10 /ngcp-data/influxdb/data/telegraf/autogen/116/000000035-000000002.tsm
>>
>>    786465  52088 -rw-r--r--   1 influxdb influxdb 53336665 Feb  4  2019 /ngcp-data/influxdb/data/telegraf/autogen/89/000000037-000000002.tsm
>>
>>    805776  51952 -rw-r--r--   1 influxdb influxdb 53193820 Feb 18  2019 /ngcp-data/influxdb/data/telegraf/autogen/107/000000035-000000002.tsm
>>
>>    802555  51952 -rw-r--r--   1 influxdb influxdb 53192981 Mar 18 06:10 /ngcp-data/influxdb/data/telegraf/autogen/143/000000035-000000002.tsm
>>
>>    788949  51868 -rw-r--r--   1 influxdb influxdb 53111137 Feb 11  2019 /ngcp-data/influxdb/data/telegraf/autogen/98/000000035-000000002.tsm
>>
>>      1629  51736 -rw-r--r--   1 influxdb influxdb 52974717 Mar 25 06:10 /ngcp-data/influxdb/data/telegraf/autogen/152/000000035-000000002.tsm
>>
>>    801852  51680 -rw-r--r--   1 influxdb influxdb 52913946 Dec  3  2018 /ngcp-data/influxdb/data/telegraf/autogen/8/000000035-000000002.tsm
>>
>>    788959  51628 -rw-r--r--   1 influxdb influxdb 52858953 Jan 28  2019 /ngcp-data/influxdb/data/telegraf/autogen/80/000000036-000000002.tsm
>>
>>    801858  51576 -rw-r--r--   1 influxdb influxdb 52813641 Dec 17  2018 /ngcp-data/influxdb/data/telegraf/autogen/26/000000035-000000002.tsm
>>
>>    799440  51476 -rw-r--r--   1 influxdb influxdb 52707507 Dec 10  2018 /ngcp-data/influxdb/data/telegraf/autogen/17/000000035-000000002.tsm
>>
>>    802196  51464 -rw-r--r--   1 influxdb influxdb 52696485 Dec 24  2018 /ngcp-data/influxdb/data/telegraf/autogen/35/000000035-000000002.tsm
>>
>>    799825  51428 -rw-r--r--   1 influxdb influxdb 52659165 Dec 31  2018 /ngcp-data/influxdb/data/telegraf/autogen/44/000000036-000000002.tsm
>>
>>    788979  51324 -rw-r--r--   1 influxdb influxdb 52551175 Jan  7  2019 /ngcp-data/influxdb/data/telegraf/autogen/53/000000035-000000002.tsm
>>
>>    799822  51292 -rw-r--r--   1 influxdb influxdb 52520744 Jan 14  2019 /ngcp-data/influxdb/data/telegraf/autogen/62/000000035-000000002.tsm
>>
>>    800201  51284 -rw-r--r--   1 influxdb influxdb 52514765 Jan 21  2019 /ngcp-data/influxdb/data/telegraf/autogen/71/000000035-000000002.tsm
>>
>>    792992  48276 -rw-r--r--   1 influxdb influxdb 49427173 Jun 11 20:30 /ngcp-data/influxdb/data/telegraf/autogen/232/000000034-000000002.tsm
>>
>>    793320  42308 -rw-r--r--   1 influxdb influxdb 43322135 Jun 17 06:10 /ngcp-data/influxdb/data/telegraf/autogen/243/000000028-000000002.tsm
>>
>>    794576  19064 -rw-r--r--   1 influxdb influxdb 19519646 Apr  8 06:10 /ngcp-data/influxdb/data/telegraf/autogen/170/000000015-000000002.tsm
>>
>>    801586  16756 -rw-r--r--   1 influxdb influxdb 17156397 Nov 26  2018 /ngcp-data/influxdb/data/telegraf/autogen/3/000000012-000000002.tsm
>>
>>    788589   4844 -rw-r--r--   1 influxdb influxdb  4956334 Jun 14 02:53 /ngcp-data/influxdb/data/telegraf/autogen/230/000000018-000000002.tsm
>>
>>    789713     12 -rw-r--r--   1 influxdb influxdb  4194304 Aug 19 05:14 /ngcp-data/influxdb/data/telegraf/_series/07/0000
>>
>>    789711      8 -rw-r--r--   1 influxdb influxdb  4194304 Jul 14 21:18 /ngcp-data/influxdb/data/telegraf/_series/06/0000
>>
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>> *Matthew Ogden*
>>
>> Management
>>
>> TenacIT
>>
>>
>>
>>
>>
>> *Strategic IT Consulting *•* Advanced Networking *• *Virtualisation*
>>
>> *Custom Development *• *Hosting *• *Syspro Support  *• *MS Licensing*
>>
>> National Tel: 041 10 10 100 | Cell: 084 205 4445 | Email:
>> matthew at tenacit.net
>>
>> CT Tel: 021 201 0333 | Skype Name: matthew.ogden | Web:
>> http://www.tenacit.net
>>
>>
>>>>
>
>
> --
>
>
>
>
>
> *Matthew Ogden*
>
> Management
>
> TenacIT
>
>
>
>
>
> *Strategic IT Consulting *•* Advanced Networking *• *Virtualisation*
>
> *Custom Development *• *Hosting *• *Syspro Support  *• *MS Licensing*
>
> National Tel: 041 10 10 100 | Cell: 084 205 4445 | Email:
> matthew at tenacit.net
>
> CT Tel: 021 201 0333 | Skype Name: matthew.ogden | Web:
> http://www.tenacit.net
>
>
>


-- 





*Matthew Ogden*

Management

TenacIT





*Strategic IT Consulting *•* Advanced Networking *• *Virtualisation*

*Custom Development *• *Hosting *• *Syspro Support  *• *MS Licensing*

National Tel: 041 10 10 100 | Cell: 084 205 4445 | Email:
matthew at tenacit.net

CT Tel: 021 201 0333 | Skype Name: matthew.ogden | Web:
http://www.tenacit.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20190822/757bb0ab/attachment-0002.html>


More information about the Spce-user mailing list