Home-assistant.db deleted, but not re-created (Hassio)

Configuration
1

Hi

Since my home-assistant.db was really large (almost 2GB) I decided to deleted (I have read some message about it), but now it has not been created again.

I have Maria DB and this is my config

recorder:
  purge_keep_days: 1
  purge_interval: 1
  db_url: mysql://hass:xxxxxx@core-mariadb/homeassistant
  exclude:
    entities:
      - camera.meteoeu
      - camera.meteoit
      - camera.patio
      - camera.porta
      - camera.vialetto

The Maria DB Log ends with

[INFO] Start MariaDB
181205 18:21:27 mysqld_safe Logging to '/data/databases/core-mariadb.err'.
181205 18:21:27 mysqld_safe Starting mysqld daemon with databases from /data/databases
[INFO] Init custom database
[INFO] Create database homeassistant
[INFO] Init/Update users
[INFO] Create user hass
[INFO] Init/Update rights
[INFO] Alter rights for hass@% - homeassistant

What can I do/check?

Thanks

2

If you use Maria DB, there will be no home-assistant.db file to create.
Maria DB looks good. What is the problem?

3

@VDRainer thanks

I didn’t know about it.

My issue is that when I try to see the historical data, I get stuck in a white page, without showing the sensors and other stuff, and the browser hangs asking me if I want to wait or close the page.

Where I can see how big is the db using MariaDb?

Is there another Db to use to get better performance looking for historical data?

Thanks

4

Same here. I switched to mariadb but same as using HA database. I think there is something in my setup flooding the logs. I’m not sure. I don’t know how to check mariadb to see whats up…

5

I will revert back to standard DB and then try to limit recorder and history like this

recorder:
  purge_keep_days: 7
  purge_interval: 1
  exclude:
    domains:
      - automation
      - weblink
      - updater
      - sensor
      - switch
      - media_player
      - light
    entities:
      - sun.sun

history:
  exclude:
    domains:
      - automation
      - weblink
      - updater
      - sensor
      - switch
      - media_player
      - light

and then I will look how it’s going