search

MariaDB / mariadb-docker

Docker Official Image packaging for MariaDB
https://mariadb.org
GNU General Public License v2.0
764 stars 440 forks source link

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

Open bsafh opened 1 month ago

bsafh commented 1 month ago

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 commented 1 month ago

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 commented 3 weeks ago

ref: https://github.com/home-assistant/core/issues/123179