Add config parameters from mariadb-server.cnf to Addon config in HA

[bsafh]

Today I tried updating to HA 2024.08.0, which includes a database update.
This database update fallen with "too many locks", because it is running too long on my rather big database.

I don't mind the time it runs, but it just fails.

To work around this, the parameter innodb_buffer_pool_size can be increased. Theoretically. In reality there is no way of doing this.

I understand that the addon is tuned to a low-end machine like a Raspberry Pi. But well, my HA supervised instance run on a VM with 12 virt-CPUs and 12 GB RAM. It really would profit from different MariaDB settings, preferably all of those explicitly found in the mariadb-server.cnf found in the addons directory.

[grooverdan]

This database update fallen with "too many locks", because it is running too long on my rather big database.

Which MariaDB version? This a migration slowness some people are mentioning in the HA core issues?

To work around this, the parameter innodb_buffer_pool_size can be increased. Theoretically. In reality there is no way of doing this.

Why not? Put --innodb-log-buffer-size=6G and --innodb-log-file-size=6G on the command line of the container start.

This one?
https://github.com/home-assistant/addons/blob/master/mariadb/rootfs/etc/my.cnf.d/mariadb-server.cnf

I can't see much good justification for any of the settings however it can be used with:

https://hub.docker.com/_/mariadb/ -> "Using a custom MariaDB configuration file"

[grooverdan]

ref: home-assistant/core#123179