Moved state's to influxdb, is that a good or bad thing with the new statistics for energy?

Configuration
1

I moved my ‘state’ to influxdb by this config:

host: a0d7b954-influxdb
port: 8086
database: homeassistant
username: !secret ha-influx-user
password: !secret ha-influx-pw
max_retries: 3
default_measurement: state
include:
  domains:
    - sensor
exclude:
  domains:
    - updater
  entities:
    - sun.sun
    - sensor.time
    - sensor.time_date
    - sensor.date
    - sensor.date_time
    - sensor.date_time_iso
    - sensor.yr_symbol
    - group.weather
    - sensor.unifi_download_speed
    - sensor.unifi_upload_speed

And I have my recorder in MySQL:

# Set up external DB on HASSIO
db_url: !secret mysqlconnection
purge_keep_days: 14
exclude:
  domains:
    - updater
    - camera
    - device_tracker
    - sun
    - weather
    - calendar
  entities:
    - sensor.time
    - sensor.time_date
    - sensor.date
    - sensor.date_time
    - sensor.date_time_iso
    - sensor.yr_symbol
    - group.weather
    - sensor.paul_hibbert
    - sensor.drzzs
    - sensor.intermit_tech
    - sensor.repairguydk
    - sensor.the_hook_up

But is that good or bad with the new energy measurement and statistics? I think the last one with MySQL is good for that, right? But the first might be bad? Does the influxdb storing of state’s remove the storing of states in MySQL, or is it just stored both places?

2

Normally this. You have data in influxdb and in mySQL But since you excluded them from mySQL, it is not there. And the energy functionality does not work with Influxdb

Nop, domain sensor is not excluded in mySQL, so they are in both.

3

I’m afraid to ask what this is (I know who it is):

I only use includes for influxdb. That way I only store long term the data I actually use in Grafana dashboards.

4

Paul Hibbert, is that not the guy who claims Zigbee and Wifi are the same ?

5

Ha ha, it’s not something crazy, it’s this

Might be a good idea to use includes for influx instead…

6

The only disadvantage is that when (not “if”) you think of a new Grafana dashboard idea and you have to add a new entity to influxdb you have no data prior to that date.

1 Like
7

No, he’s the one that’s airhumping zigbee and corporate greed :slight_smile: