{"id":752,"date":"2022-04-16T08:53:35","date_gmt":"2022-04-16T07:53:35","guid":{"rendered":"https:\/\/www.cipv6.de\/worp\/?p=752"},"modified":"2024-12-16T10:33:36","modified_gmt":"2024-12-16T09:33:36","slug":"influxdb-show-real-database-size-in-grafana","status":"publish","type":"post","link":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","title":{"rendered":"Influxdb: show real database size in Grafana"},"content":{"rendered":"\n<p>Influxdb has no useful functions to look at the real database size.<\/p>\n\n\n\n<p>As I have created a retention policy combined with continuous queries I want to see the exact values per database.<\/p>\n\n\n\n<p>I use the following approach:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>in Crontab a bash is executed to get the real influxes database values<\/li><li>the values are then pushed into a dedicated database for storing  the values<\/li><li>Grafana dashboard setup to show the values<\/li><\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a0ed24d3ed7a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a0ed24d3ed7a\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#Crontab\" >Crontab<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#Bash-script\" >Bash-script<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#Grafana-dashboard\" >Grafana-dashboard<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Crontab\"><\/span>Crontab<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>vi \/etc\/crontab and add the following line:<\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\"><code lang=\"bash\" class=\"language-bash\">*\/30  * * * *\troot\tsh \/home\/pi\/test.sh &gt;\/dev\/null 2&gt;&amp;1<\/code><\/pre>\n\n\n\n<p>the script <strong>\/home\/pi\/test.sh<\/strong> is executed every half an hour<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bash-script\"><\/span>Bash-script <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>vi <strong>\/home\/pi\/test.sh<\/strong> and paste this code in:<br><\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\"><code lang=\"bash\" class=\"language-bash\">#!\/usr\/bin\/env bash\n\n#get real database size\ntelegraf_data=$(du -s \/var\/lib\/influxdb\/data\/telegraf | awk '{print $1}')\n_internal_data=$(du -s \/var\/lib\/influxdb\/data\/_internal | awk '{print $1}')\nopenhab_db_data=$(du -s \/var\/lib\/influxdb\/data\/openhab_db | awk '{print $1}')\ncollectd_data=$(du -s \/var\/lib\/influxdb\/data\/collectd | awk '{print $1}')\nmydbsize_data=$(du -s \/var\/lib\/influxdb\/data\/mydbsize | awk '{print $1}')\n\n#print real database size to screen\necho \"******\"\necho $telegraf_data\necho $_internal_data\necho $openhab_db_data\necho $collectd_data\necho $mydbsize_data\necho \"******\"\n\n#push real database size values to database mydbsize\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=telegraf Size='\"$telegraf_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=_internal Size='\"$_internal_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=openhab_db Size='\"$openhab_db_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=collectd Size='\"$collectd_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=mydbsize Size='\"$mydbsize_data\"' '\n\n#End\n\n<\/code><\/pre>\n\n\n\n<p>I have created a dedicated database for these measurements in my case:<br><\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\"><code lang=\"bash\" class=\"language-bash\">root@raspi5:\/home\/pi# influx\nConnected to http:\/\/localhost:8086 version 1.8.10\nInfluxDB shell version: 1.8.10\n> create database mydbsize<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Grafana-dashboard\"><\/span>Grafana-dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Create a new db-source in Grafana:<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"762\" data-permalink=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/cleanshot-2022-04-16-at-09-24-452x\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?fit=3028%2C2702&amp;ssl=1\" data-orig-size=\"3028,2702\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"CleanShot-2022-04-16-at-09.24.45@2x\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?fit=840%2C750&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=840%2C750&#038;ssl=1\" alt=\"\" class=\"wp-image-762\" width=\"840\" height=\"750\" srcset=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=1024%2C914&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=300%2C268&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=768%2C685&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=1536%2C1371&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=2048%2C1828&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?resize=1200%2C1071&amp;ssl=1 1200w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?w=1680&amp;ssl=1 1680w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?w=2520&amp;ssl=1 2520w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Add the queries per database in Grafana<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"763\" data-permalink=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/cleanshot-2022-04-16-at-09-30-302x\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?fit=3052%2C3002&amp;ssl=1\" data-orig-size=\"3052,3002\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"CleanShot-2022-04-16-at-09.30.30@2x\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?fit=840%2C826&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=840%2C826&#038;ssl=1\" alt=\"\" class=\"wp-image-763\" width=\"840\" height=\"826\" srcset=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=1024%2C1007&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=300%2C295&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=768%2C755&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=1536%2C1511&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=2048%2C2014&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?resize=1200%2C1180&amp;ssl=1 1200w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?w=1680&amp;ssl=1 1680w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30%402x.png?w=2520&amp;ssl=1 2520w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<p>Panel shown as JSON-data<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"json\" class=\"language-json\">{\n  \"id\": 8,\n  \"gridPos\": {\n    \"h\": 14,\n    \"w\": 23,\n    \"x\": 0,\n    \"y\": 9\n  },\n  \"type\": \"timeseries\",\n  \"title\": \"DB size\",\n  \"datasource\": {\n    \"type\": \"influxdb\",\n    \"uid\": \"cq2DkaZgk\"\n  },\n  \"pluginVersion\": \"8.4.4\",\n  \"links\": [],\n  \"fieldConfig\": {\n    \"defaults\": {\n      \"custom\": {\n        \"drawStyle\": \"line\",\n        \"lineInterpolation\": \"smooth\",\n        \"barAlignment\": 0,\n        \"lineWidth\": 2,\n        \"fillOpacity\": 10,\n        \"gradientMode\": \"none\",\n        \"spanNulls\": true,\n        \"showPoints\": \"auto\",\n        \"pointSize\": 4,\n        \"stacking\": {\n          \"mode\": \"none\",\n          \"group\": \"A\"\n        },\n        \"axisPlacement\": \"auto\",\n        \"axisLabel\": \"\",\n        \"scaleDistribution\": {\n          \"type\": \"log\",\n          \"log\": 2\n        },\n        \"hideFrom\": {\n          \"tooltip\": false,\n          \"viz\": false,\n          \"legend\": false\n        },\n        \"thresholdsStyle\": {\n          \"mode\": \"off\"\n        },\n        \"lineStyle\": {\n          \"fill\": \"solid\"\n        }\n      },\n      \"color\": {\n        \"mode\": \"palette-classic\"\n      },\n      \"mappings\": [],\n      \"thresholds\": {\n        \"mode\": \"absolute\",\n        \"steps\": [\n          {\n            \"color\": \"green\",\n            \"value\": null\n          },\n          {\n            \"color\": \"red\",\n            \"value\": 80\n          }\n        ]\n      },\n      \"unit\": \"deckbytes\"\n    },\n    \"overrides\": []\n  },\n  \"options\": {\n    \"tooltip\": {\n      \"mode\": \"multi\",\n      \"sort\": \"none\"\n    },\n    \"legend\": {\n      \"displayMode\": \"table\",\n      \"placement\": \"bottom\",\n      \"calcs\": [\n        \"lastNotNull\",\n        \"max\",\n        \"min\"\n      ]\n    }\n  },\n  \"targets\": [\n    {\n      \"alias\": \"_internal\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"A\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"_internal\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"collectd\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"B\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"collectd\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"openhab_db\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"C\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"openhab_db\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"mydbsize\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"autogen\",\n      \"refId\": \"D\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"mydbsize\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"telegraf\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"E\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"telegraf\"\n        }\n      ]\n    }\n  ]\n}<\/code><\/pre>\n\n\n\n<p>Example-view of dashboard:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"764\" data-permalink=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/cleanshot-2022-04-16-at-09-31-312x\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?fit=3646%2C2614&amp;ssl=1\" data-orig-size=\"3646,2614\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"CleanShot-2022-04-16-at-09.31.31@2x\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?fit=840%2C602&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=840%2C602&#038;ssl=1\" alt=\"\" class=\"wp-image-764\" width=\"840\" height=\"602\" srcset=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?w=3646&amp;ssl=1 3646w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=300%2C215&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=1024%2C734&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=768%2C551&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=1536%2C1101&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=2048%2C1468&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?resize=1200%2C860&amp;ssl=1 1200w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?w=1680&amp;ssl=1 1680w, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?w=2520&amp;ssl=1 2520w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>done!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database. I use the following approach: in Crontab a bash is executed to get the real influxes database valuesthe values are then pushed into &hellip; <a href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Influxdb: show real database size in Grafana&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"template-page-builder.php","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[65,66,61],"tags":[44,27,26,45,25,55],"class_list":["post-752","post","type-post","status-publish","format-standard","hentry","category-home-assistant","category-influx","category-linux","tag-database","tag-database-size","tag-grafana","tag-grafanba","tag-influxdb","tag-raspi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Influxdb: show real database size in Grafana - cipv6.de<\/title>\n<meta name=\"description\" content=\"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Influxdb: show real database size in Grafana - cipv6.de\" \/>\n<meta property=\"og:description\" content=\"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/\" \/>\n<meta property=\"og:site_name\" content=\"cipv6.de\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-16T07:53:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-16T09:33:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\" \/>\n<meta name=\"author\" content=\"ugu5ma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Influxdb: show real database size in Grafana\" \/>\n<meta name=\"twitter:description\" content=\"Influxdb has no useful functions to look at the real database size.As I have created a retention policy combined with continuous queries I want to see the exact values per database.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?fit=3646%2C2614&ssl=1\" \/>\n<meta name=\"twitter:creator\" content=\"@ugu5ma\" \/>\n<meta name=\"twitter:site\" content=\"@ugu5ma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ugu5ma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\"},\"author\":{\"name\":\"ugu5ma\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\"},\"headline\":\"Influxdb: show real database size in Grafana\",\"datePublished\":\"2022-04-16T07:53:35+00:00\",\"dateModified\":\"2024-12-16T09:33:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\"},\"wordCount\":143,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\",\"keywords\":[\"database\",\"database size\",\"grafana\",\"Grafanba\",\"influxdb\",\"Raspi\"],\"articleSection\":[\"Home-Assistant\",\"Influx\",\"Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\",\"url\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\",\"name\":\"Influxdb: show real database size in Grafana - cipv6.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\",\"datePublished\":\"2022-04-16T07:53:35+00:00\",\"dateModified\":\"2024-12-16T09:33:36+00:00\",\"description\":\"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45%402x.png?fit=3028%2C2702&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45%402x.png?fit=3028%2C2702&ssl=1\",\"width\":3028,\"height\":2702},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Influxdb: show real database size in Grafana\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#website\",\"url\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/\",\"name\":\"cipv6.de\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\",\"name\":\"ugu5ma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\",\"caption\":\"ugu5ma\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\"},\"sameAs\":[\"https:\\\/\\\/cipv6.de\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Influxdb: show real database size in Grafana - cipv6.de","description":"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","og_locale":"en_US","og_type":"article","og_title":"Influxdb: show real database size in Grafana - cipv6.de","og_description":"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.","og_url":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","og_site_name":"cipv6.de","article_published_time":"2022-04-16T07:53:35+00:00","article_modified_time":"2024-12-16T09:33:36+00:00","og_image":[{"url":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png","type":"","width":"","height":""}],"author":"ugu5ma","twitter_card":"summary_large_image","twitter_title":"Influxdb: show real database size in Grafana","twitter_description":"Influxdb has no useful functions to look at the real database size.As I have created a retention policy combined with continuous queries I want to see the exact values per database.","twitter_image":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31%402x.png?fit=3646%2C2614&ssl=1","twitter_creator":"@ugu5ma","twitter_site":"@ugu5ma","twitter_misc":{"Written by":"ugu5ma","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#article","isPartOf":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/"},"author":{"name":"ugu5ma","@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d"},"headline":"Influxdb: show real database size in Grafana","datePublished":"2022-04-16T07:53:35+00:00","dateModified":"2024-12-16T09:33:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/"},"wordCount":143,"commentCount":0,"publisher":{"@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d"},"image":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png","keywords":["database","database size","grafana","Grafanba","influxdb","Raspi"],"articleSection":["Home-Assistant","Influx","Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","url":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","name":"Influxdb: show real database size in Grafana - cipv6.de","isPartOf":{"@id":"https:\/\/www.cipv6.de\/worp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage"},"image":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png","datePublished":"2022-04-16T07:53:35+00:00","dateModified":"2024-12-16T09:33:36+00:00","description":"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.","breadcrumb":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage","url":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?fit=3028%2C2702&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45%402x.png?fit=3028%2C2702&ssl=1","width":3028,"height":2702},{"@type":"BreadcrumbList","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cipv6.de\/worp\/"},{"@type":"ListItem","position":2,"name":"Influxdb: show real database size in Grafana"}]},{"@type":"WebSite","@id":"https:\/\/www.cipv6.de\/worp\/#website","url":"https:\/\/www.cipv6.de\/worp\/","name":"cipv6.de","description":"","publisher":{"@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cipv6.de\/worp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d","name":"ugu5ma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g","caption":"ugu5ma"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g"},"sameAs":["https:\/\/cipv6.de"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uBTs-c8","jetpack-related-posts":[{"id":630,"url":"https:\/\/www.cipv6.de\/worp\/index.php\/2021\/01\/31\/daily-compression-of-influxdb\/","url_meta":{"origin":752,"position":0},"title":"daily compression of InfluxDB","author":"ugu5ma","date":"January 31, 2021","format":false,"excerpt":"InfluxDB is an open source time series database built by InfluxData and used in e.g. Openhab for data persistance.For small computers like raspi's it is a best practice to compress the database regurlarly. Why not using cron ? Well, it works.. the only (security)-drawback is to grant \/bin\/bash to the\u2026","rel":"","context":"In &quot;Influx&quot;","block_context":{"text":"Influx","link":"https:\/\/www.cipv6.de\/worp\/index.php\/category\/linux\/influx\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":703,"url":"https:\/\/www.cipv6.de\/worp\/index.php\/2021\/08\/15\/influxd-systemd-start-shpid-failed-to-reach-influxdb-http-endpoint-at-http-localhost8086-health\/","url_meta":{"origin":752,"position":1},"title":"influxd-systemd-start.sh[PID]: Failed to reach influxdb http endpoint at http:\/\/localhost:8086\/health","author":"ugu5ma","date":"August 15, 2021","format":false,"excerpt":"on my Raspi4 the last installed influxd-package was no more able to start the service.CPU-load was at 100%, the \"systemctl start influxd\" routine was running in a loop.As the smarthome generates many data the service took longer to start as expected by the new startup-script influxd-systemd-start.sh . Fix:in .\/usr\/lib\/influxdb\/scripts\/influxd-systemd-start.sh: increase\u2026","rel":"","context":"In &quot;Influx&quot;","block_context":{"text":"Influx","link":"https:\/\/www.cipv6.de\/worp\/index.php\/category\/linux\/influx\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":931,"url":"https:\/\/www.cipv6.de\/worp\/index.php\/2024\/08\/08\/water-temperature\/","url_meta":{"origin":752,"position":2},"title":"Bosch Heat-pump, Influx,  Grafana and Home-Assistant: get the water-temperature presented","author":"ugu5ma","date":"August 8, 2024","format":false,"excerpt":"Used Hard\/Software:Home Assistant Frontend 20240806.1 Core 2024.8.0 Supervisor 2024.08.0 Operating System 12.4HA-Integration: Bosch custom component v0.26.1 It was a hard time to find the right Grafana-settings to get the water-temperature presented.Bosch\/Home-Assistant transports this value based on the state-series: Hence Grafana needs a statement as shown: Example output: Done :)","rel":"","context":"In &quot;Home-Assistant&quot;","block_context":{"text":"Home-Assistant","link":"https:\/\/www.cipv6.de\/worp\/index.php\/category\/linux\/home-assistant\/"},"img":{"alt_text":"Grafana water-temperature","src":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/08\/CleanShot-2024-08-08-at-18.31.01%402x.png?fit=1200%2C432&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/08\/CleanShot-2024-08-08-at-18.31.01%402x.png?fit=1200%2C432&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/08\/CleanShot-2024-08-08-at-18.31.01%402x.png?fit=1200%2C432&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/08\/CleanShot-2024-08-08-at-18.31.01%402x.png?fit=1200%2C432&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/08\/CleanShot-2024-08-08-at-18.31.01%402x.png?fit=1200%2C432&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":261,"url":"https:\/\/www.cipv6.de\/worp\/index.php\/2018\/11\/13\/android-get-values-of-the-temperature-sensor-show-them-on-the-display\/","url_meta":{"origin":752,"position":3},"title":"Android: get values of the Temperature Sensor, show them on the display","author":"ugu5ma","date":"November 13, 2018","format":false,"excerpt":"Mainactivity.java: [code] public class MainActivity extends AppCompatActivity implements SensorEventListener { private SensorManager mSM; private Sensor mTemp; private TextView sensorTextView; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); sensorTextView = findViewById(R.id.sensorTextview); mSM = (SensorManager) getSystemService(SENSOR_SERVICE); mTemp = mSM.getDefaultSensor(Sensor.TYPE_AMBIENT_TEMPERATURE); } @Override public void onSensorChanged(SensorEvent sensorEvent) { float tmpval = sensorEvent.values[0]; sensorTextView.setText(\"Temp :\"\u2026","rel":"","context":"In \"Android\"","block_context":{"text":"Android","link":"https:\/\/www.cipv6.de\/worp\/index.php\/tag\/android\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1279,"url":"https:\/\/www.cipv6.de\/worp\/index.php\/2025\/02\/25\/secure-networking-with-hub-and-spoke-topology-using-wireguard-and-ebgp\/","url_meta":{"origin":752,"position":4},"title":"Secure Networking with Hub-and-Spoke Topology Using WireGuard and eBGP","author":"ugu5ma","date":"February 25, 2025","format":false,"excerpt":"Free Range Routing (FRR)\u00a0is a powerful, open-source routing software suite that provides implementations of various routing protocols, including BGP, OSPF, IS-IS, RIP, PIM, and more. It\u2019s designed to run on Linux and Unix-like systems, making it a flexible solution for a wide range of network setups\u2014from small labs to large-scale\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2025\/02\/VPN-BGP-WireGuard-topology.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2025\/02\/VPN-BGP-WireGuard-topology.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2025\/02\/VPN-BGP-WireGuard-topology.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2025\/02\/VPN-BGP-WireGuard-topology.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1103,"url":"https:\/\/www.cipv6.de\/worp\/index.php\/2025\/01\/11\/automate-your-cloud-backups-rclone-and-duplicati\/","url_meta":{"origin":752,"position":5},"title":"Automate Your Cloud Backups: rclone and Duplicati","author":"ugu5ma","date":"January 11, 2025","format":false,"excerpt":"In today's digital age, safeguarding your data is more crucial than ever. With the increasing reliance on cloud storage, it's essential to have a robust backup strategy in place. This blog post will guide you through automating your cloud backups (like Onedrive in this example) using\u00a0rclone\u00a0and\u00a0Duplicati\u00a0on a Linux system (in\u2026","rel":"","context":"In &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.cipv6.de\/worp\/index.php\/category\/linux\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/12\/himage.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/12\/himage.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/12\/himage.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.cipv6.de\/worp\/wp-content\/uploads\/2024\/12\/himage.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/posts\/752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/comments?post=752"}],"version-history":[{"count":0,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/posts\/752\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/media?parent=752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/categories?post=752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/tags?post=752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}