November 8, 20223 yr I installed mariadb and photoprism, and currently tweaking performance because the latency is really high after adding 200k+ photos and videos. Following https://docs.photoprism.app/getting-started/troubleshooting/performance/ I hope to add `--innodb-buffer-pool-size=1G` parameter some where to adjust the buffer pool size. I tried it in both Extra Parameters and Post Arguments, non of them worked. Is there a `docker-compose.yml` for mariadb to update? Or where else can I add the parameter? Thanks! Jason
March 9, 20233 yr Came across this thread as I was also looking to up the pool size. I think what you are looking for is in the /config directory of the MariaDB docker. There is a custom.cnf file that you can edit and has the InnoDB parameters in it like: innodb_buffer_pool_size = 2048M
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.