I wound up just abandoning the mariadb database. I really wasn’t interested in past information older than 30 days, so I just migrated my setup to a new instance and left the old behind. All the integrations and adding I had came over just fine and began with data from the point were I dropped mariadb and started using sqlite. I went back to sqlite about a year ago, and things are all good with the new version running on a raspberry pi 4 on a Samsung 128GB sd card with plenty of space on it for HAOS and data. When I do a backup it is around 80 MB so not using much of the SD card at all. I have been running HA on SD cards for about 7 years or so with no problems (knock on wood)!
I did not run the mariadb server on a separate machine, so that probably accounts for the ‘increase’ in performance. I’m happy with the sqlite setup now.
It worked for me when I realized there really wasn’t any data I left behind that I would miss.
I do recall someone starting a thread with a howto for migrating back to sqlite, but didn’t use it myself.
Regards!
PS. here is a link to the information I found: