Cleanup mariadb

[swa72]

• You can purge recorder via service. Shows results after 30min, simply wait. Even more results after midnight.
• Optimize tables with https://www.reddit.com/r/homeassistant/comments/h86y46/psa_easy_fix_for_mariadbmysql_database_files_that/
  • you need phpMyAdmin

    OPTIMIZE TABLE states;
    OPTIMIZE TABLE events;

• Clean recorder with https://community.home-assistant.io/t/how-to-keep-your-recorder-database-size-under-control/295795
  • Works with mariadb as well, you need phpMyAdmin
  • simply add the top using entities to the recorder's exclude section in configuration.yaml
  • "Zeige Datensätze 0 - 24 (860 insgesamt, Die Abfrage dauerte 141.0029 Sekunden.)" with approx. 1GB of data
  • don't forget to restart HA to make the recorder use the new data