I tried migrating my home assistant setup from a docker-compose setup first to a supervised bare metal setup on the same machine (debian 10) and then to a standalone proxmox server. For both supervised setups I moved mariadb to the addon. My db performance suffered tremendously resulting in very long response times for everything related to history or similar. At some point I tried pointing the supervised setup to my “old” docker based mariadb which resulted in a significant speed gain. Does anyone have an explanation? For the moment i switched back to the docker-compose model but quite like some of the advantages by a supervised setup e.g. visual studio code addon.
My mariadb is approximately 800 mb when dumped as sql, I moved the database by performing a row for row copy using dbeaver.