on 07-13-2014 1:34 PM
Hello Everyone,
I have been checking a maxdb system and can see huge memory consumption occurring:
top - 12:29:10 up 842 days, 2:59, 5 users, load average: 18.59, 17.80, 11.77
Tasks: 728 total, 2 running, 723 sleeping, 0 stopped, 3 zombie
Cpu(s): 8.5%us, 0.7%sy, 0.0%ni, 88.8%id, 0.3%wa, 0.0%hi, 0.3%si, 1.4%st
Mem: 47509M total, 47129M used, 379M free, 210M buffers
Swap: 20479M total, 1475M used, 19004M free, 5386M cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26644 sdb 20 0 39.8g 38g 306m S 126 82.3 52654:06 kernel
7136 sdb 20 0 77304 16m 4692 S 8 0.0 1:12.69 dbmsrv
2860 root 20 0 0 0 0 S 3 0.0 2837:24 nfsiod
208 root 20 0 0 0 0 S 2 0.0 2448:01 rpciod/2
I could not see any long running db transactions, background jobs, deadlocks
Please provide any valuable inputs on how to check the issue further
Regards,
Vinay
Hello Vinay,
what are you wondering about?
That the database uses 82.3% of the memory?
In MAXDB there exists a parameter called:
CACHE_SIZE (MaxDB < 7.7.03) respectively CacheMemorySize (MaxDB >= 7.7.03)
"The value specifies the i/o capable memory used by different
MaxDB components in particular the data cache, converter and
the shared catalog cache."
When the database starts it allocates the memory given by the parameter. This memory is reserved for the db. It will not become free if there is no activity on the db.
See also:
MaxDB Memory Sizing - MaxDB - SCN Wiki
Regards,
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.