Hey Alexey Thanks for the advise, I changed TempCacheLimit to 2100000000, last night and it looks like it had a positive effect on the disk queue size on sda. I have read a lot about Firebird tuning however I have never come across that limit on fb 2.5
https://pasteboard.co/IGsU650A.png https://pasteboard.co/IGsU650A.png The green line is when I updated the config. The spikes around midnight is due to backup/restore. The queue size has gone from around 1 to 0,1-0,2 during office hours. However the amount of wirte access to sda, did not change after the config change. Perhaps the sensor that we use monitors the writes Firebird makes when firebird sorts response? https://pasteboard.co/IGt93ec.png https://pasteboard.co/IGt93ec.png To accommodate further growth in users I am planning an upgrade to Firebird 3.0.4(SuperServer) this weekend. The server will be the same, however with a ram upgrade to 192Gb. I am planning to use the following config, do you or anyone else see any problems? Firebird config DefaultDbCachePages = 6000K #96Gb (page size 16Kb) FileSystemCacheThreshold = 20000K TempCacheLimit = 10G #10Gb TempBlockSize = 2M LockMemSize = 116117248 LockHashSlots = 40099 OS config Vm.pagecache = 30 Vm.swappiness = 10 vm.min_free_kbytes = 1048576 vm.max_map_count=250000 fs.file-max=2097152 net.core.somaxconn = 4096 net.core.netdev_max_backlog = 65536 net.core.optmem_max = 25165824 Thomas Kragh
