liujason Posted November 8, 2022 Share Posted November 8, 2022 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 Quote Link to comment
naebula Posted November 28, 2022 Share Posted November 28, 2022 I'm looking to do the same, did you ever figure it out? Quote Link to comment
liujason Posted November 28, 2022 Author Share Posted November 28, 2022 Not yet. Quote Link to comment
kahunamike Posted March 9, 2023 Share Posted March 9, 2023 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 Quote Link to comment
Recommended Posts
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.