panel_custom:
  - name: server_state
    sidebar_title: 'System'
    sidebar_icon: mdi:server
    js_url: /api/hassio/app/entrypoint.js
    url_path: 'hassio/system'
    embed_iframe: true
    require_admin: true
    config:
      ingress: core_configurator

homeassistant:
  packages: !include_dir_merge_named includes/packages

    sensor:    
    - platform: systemmonitor
      resources:
      - type: processor_use
      - type: disk_use_percent
        arg: /
      - type: memory_use_percent
      - type: last_boot
      - type: disk_free
        arg: /
      - type: processor_temperature

mysql_secure_installation

mysql

CREATE USER 'dbadmin'@'localhost' IDENTIFIED BY 'dbpassword';

GRANT ALL ON *.* TO 'dbadmin'@'localhost' IDENTIFIED BY 'dbpassword' WITH GRANT OPTION;

GRANT ALL ON *.* TO 'dbadmin'@'192.168.0.%' IDENTIFIED BY 'dbpassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

exit

mysql -u dbadmin -p

/usr/bin/mariadb -u dbadmin -p

CREATE DATABASE homeassistant;

exit

db_link: mysql://dbadmin:dbpassword@192.168.0.41:3306/homeassistant?charset=utf8

    recorder:
      db_url: !secret db_link
      purge_keep_days: 14

MariaDB

mysql://dbadmin:dbpassword@192.168.0.41:3306/homeassistant?charset=utf8

value

SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema;

MB