Topic: Problem with productivity of basis
Help to find, please, the reason "" bases.
Each 5 minutes, basis "fades" - requests , but do not fall off, new connections are not connected and do not disappear with an error. Thus activity on the server is not present - all kernels use 0,1 %, network \disk activity - under 0. In 1-1,5 minutes all kernels \disks start to work actively as well as basis - the requests, new connections - .
fb_lock_print-h showed big kol-in Deadlock scans, here at a forum read that it can cause frequent reversal to monitoring tables. There was a trigger on a connection which climbed in the table mon$attachments, it was disconnected. The situation with deadlock scans did not change. Similar symptoms of behavior of basis are described CORE-3787, rolled away on version 2.5.6 - the problem remained.
Linux, Firebird Classic 2.5.6 x86 (were rolled away with 2.5.7 problem remained) the Size of basis: 310GB. CPU: 16 kernels, Mem: 32GB. About 200-300 simultaneous connections to basis.
DefaultDbCachePages = 1024
TempBlockSize = 2097152
TempCacheLimit = 536870912
LockMemSize = 67108864
LockHashSlots = 30011
Version: 17, Active owner: 0, Length: 67108864, Used: 19963784
Enqs: 21316962, Converts: 106998, Rejects: 29956, Blocks: 41118
Deadlock scans: 16950, Deadlocks: 0, Scan interval: 10
Acquires: 26067878, Acquire blocks: 2020423, Spin count: 0
Mutex wait: 7.8 %
Hash slots: 30011, Hash lengths (min/avg/max): 0/1/9
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (174): forward: 487352, backward: 11780228
Free owners (157): forward: 11769300, backward: 955512
Free locks (5634): forward: 11623412, backward: 10126092
Free requests (89469): forward: 3174308, backward: 19506404
Lock Ordering: Enabled