Jahresrückblick 2025 – unser neuer Blogbeitrag ist online! ✨

[crunchip]

@has3nb3inmh sagte in Frage zu Linux:

Jetzt würde ich sie gern wieder verkleinern

Puh, das ist nicht so einfach

[liv-in-sky]

@has3nb3inmh

könntest du noch kurz beschreiben, was du mit influxdb gemacht hast, damit die datenbank wieder kleiner geworden ist ?

vielleicht braucht das mal jmd anders

[Has3nb3inMH]

Ich habe die _internal "deaktiviert" und gedropt.

https://docs.influxdata.com/platform/monitoring/influxdata-platform/tools/measurements-internal/
https://docs.influxdata.com/influxdb/v1.8/query_language/manage-database/#delete-a-database-with-drop-database

[Has3nb3inMH]

@liv-in-sky

Sep 22 00:00:34 Datenbanken influxd[782]: ts=2022-09-22T00:00:34.305043Z lvl=info msg="Cache snapshot (start)" log_id=0d4c9StW000 engine=tsm1 trace_id=0d4cmb0G000 op_name=tsm1_cache_snapshot op_event=start
Sep 22 00:00:34 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:34 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 94d60fb1-3a09-11ed-848e-a61bb45>
Sep 22 00:00:34 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:34 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 94fabf75-3a09-11ed-848f-a61bb45>
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - daniel [22/Sep/2022:00:00:35 +0000] "POST /write?database=iobroker-test&db=iobroker-test&p=%5BREDACTED%5D&precision=ms&u=daniel HTTP/1.1" 204 0 "-" "-" 9532484a-3a09-11ed->
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:35 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 9536e6c2-3a09-11ed-8491-a61bb45>
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:35 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 953b749a-3a09-11ed-8492-a61bb457d>
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:35 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 954efb12-3a09-11ed-8493-a61bb457d>
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:35 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 95559794-3a09-11ed-8494-a61bb457d>
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:35 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 955e0425-3a09-11ed-8495-a61bb457d>
Sep 22 00:00:35 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:35 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 958ea499-3a09-11ed-8496-a61bb45>
Sep 22 00:00:36 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:36 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 962bb8bb-3a09-11ed-8497-a61bb45>
Sep 22 00:00:36 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:36 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 963df3f2-3a09-11ed-8498-a61bb45>
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:37 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 96680cc8-3a09-11ed-8499-a61bb457d>
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:37 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 966e3746-3a09-11ed-849a-a61bb457d>
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:37 +0000] "POST /write?database=Energie&db=Energie&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 967613c6-3a09-11ed-849b-a61bb457d>
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - daniel [22/Sep/2022:00:00:37 +0000] "POST /write?database=iobroker-test&db=iobroker-test&p=%5BREDACTED%5D&precision=ms&u=daniel HTTP/1.1" 204 0 "-" "-" 967f4814-3a09-11ed->
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:37 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 967f4fe6-3a09-11ed-849d-a61bb45>
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:37 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 967f551e-3a09-11ed-849e-a61bb45>
Sep 22 00:00:37 Datenbanken influxd[782]: [httpd] 192.168.0.46 - admin [22/Sep/2022:00:00:37 +0000] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 96853f1b-3a09-11ed-849f-a61bb45>
Sep 22 00:00:38 Datenbanken systemd[1]: man-db.service: Succeeded.
Sep 22 00:00:38 Datenbanken systemd[1]: Finished Daily man-db regeneration.

Die influxdb schreibt ne ganze menge in die syslog, nur die Frage wo ich das abstellen kann

[liv-in-sky]

@has3nb3inmh ich nutze influxdb nicht - daher werd ich dir da keine hilfe sein können

[liv-in-sky]

@has3nb3inmh sagte in Frage zu Linux:

Cache snapshot (start)

evtl das hier:

https://community.influxdata.com/t/how-managing-cache-snapshot-memory-size-with-very-different-databases/12294

oder etwas mit dem log-level von influxdb ?

[Has3nb3inMH]

@liv-in-sky

Damit beschäftige ich mich am Wochenende 👍