cancel
Showing results for 
Search instead for 
Did you mean: 

Huge Memory Consumption

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

MichaelTe
Contributor
0 Kudos

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