Differential D12337
[keyserver] Bump MariaDB --innodb-buffer-pool-size config to 14000M in docker-compose.yml Authored by ashoat on Thu, Jun 6, 8:02 PM. Tags None Referenced Files
Subscribers None
Details I noticed that I have this change on my keyserver running in production. There's been some recent discussion about this config in D12322 (see diff description). The context about this change being on my production keyserver is here on Linear. For whatever reason I never got around to diffing it up, probably because the performance improvement seem minimal and I didn't have a strong argument for it. See context Linear link above; I tested this and observed a slight performance improvement. I vaguely recall testing how long eg. 3 attempts of the same fetchServerThreadInfos query would take, before and after the change
Diff Detail
Event TimelineComment Actions For the AWS RDS configuration, I used 75% of DBInstanceClassMemory which I believe is just the RAM. This amounts to roughly 6144 MiB on the MariaDB RDS database which will hopefully lead to performance benefits compared to 1600M. Like this change, we might want to consider upping this to 14000M though on AWS Oracle suggests 50-75%: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/memory-use.html#:~:text=InnoDB%20allocates%20memory%20for%20the,75%20percent%20of%20system%20memory. |