High memory usuage,

Posted by durgaprasad m on 22-Jan-2016 12:13

Hi,

We are experiencing high memory usage for our Progress Red Hat Enterprise Linux Server release 6.6.

Progress version : 11.4

Yesterday server team has increased memory from 40gb to 50gb but no database changes has been made on that time.But once server restarted and database were backup up after that memory was showing  37gb memory.used out of 5ogb.

At 8PM online backup has happened after that server has used all memory and 100% swap memory.

what are the things we have to check from server level and database side.

The following factors can affect server performance:

• Disk I/O relating to database, before-image I/O
• Record locking
• Memory usage
• Database and index fragmentation

For example:

Before increasing memory size if we kill all the process related to database and application process it will work ?

Kindly provide your suggestions.

FYI..............

free
                     total   used                f ree shared        buffers      cached
Mem: 51496052 50346340 1149712 31566472 255540 43489644
-/+ buffers/cache: 6601156 44894896
Swap: 2098172 132092 1966080

top - 18:04:54 up 1 day, 12 min, 3 users, load average: 0.01, 0.09, 0.29
Tasks: 323 total, 1 running, 322 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.2%us, 0.1%sy, 0.0%ni, 99.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 51496052k total, 50205340k used, 1290712k free, 265012k buffers
Swap: 2098172k total, 132092k used, 1966080k free, 43492228k cached

Thanks..........

All Replies

Posted by Paul Koufalis on 22-Jan-2016 12:21

http://www.linuxatemyram.com/

You have 44 Gb free.

Posted by Libor Laubacher on 22-Jan-2016 12:26

You have nearly 44 GB free there.
How did you measure / come up with 37 GB in use etc ?

Posted by gus on 22-Jan-2016 12:26

"43492228k cached" is telling you that the filesystem cache has filled up unused memory that was not needed for something else. that is normal. looks like you have 43 GB of filesystem cache.

there are some system tuning parameters you could change to force smaller filesystem cache. i don't recall what they are off the top of my head.

but what problem are you solving ??? it is desirable to use all the memory you have for /something/. free memory is wasted memory.

> On Jan 22, 2016, at 1:14 PM, durgaprasad m wrote:

>

> Update from Progress Community [https://community.progress.com/]

>

> durgaprasad m [https://community.progress.com/members/durgaprasad1538]

>

> Hi,

>

> We are experiencing high memory usage for our Progress Red Hat Enterprise Linux Server release 6.6.

>

> Progress version : 11.4

>

> Yesterday server team has increased memory from 40gb to 50gb but no database changes has been made on that time.But once server restarted and database were backup up after that memory was showing 37gb memory.used out of 5ogb.

>

> At 8PM online backup has happened after that server has used all memory and 100% swap memory.

>

> what are the things we have to check from server level and database side.

>

> The following factors can affect server performance:

>

> • Disk I/O relating to database, before-image I/O

> • Record locking

> • Memory usage

> • Database and index fragmentation

>

> For example:

>

> Before increasing memory size if we kill all the process related to database and application process it will work ?

>

> Kindly provide your suggestions.

>

> FYI..............

>

> free

>

> total used f ree shared buffers cached

> Mem: 51496052 50346340 1149712 31566472 255540 43489644

> -/+ buffers/cache: 6601156 44894896

> Swap: 2098172 132092 1966080

>

> top - 18:04:54 up 1 day, 12 min, 3 users, load average: 0.01, 0.09, 0.29

> Tasks: 323 total, 1 running, 322 sleeping, 0 stopped, 0 zombie

> Cpu(s): 0.2%us, 0.1%sy, 0.0%ni, 99.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st

> Mem: 51496052k total, 50205340k used, 1290712k free, 265012k buffers

> Swap: 2098172k total, 132092k used, 1966080k free, 43492228k cached

>

> Thanks..........

>

> View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/22636]

>

> You received this notification because you subscribed to the forum. To stop receiving updates from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/22636/mute].

>

> Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/22636?AbuseContentId=51799f0e-2022-4f7b-85cc-729d635d49ce&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true] this post as spam/abuse.

Posted by durgaprasad m on 22-Jan-2016 12:45

Hi libor,

As I mentioned that is yesterday memory value.today it reached 50gb.

Thanks....

Posted by Paul Koufalis on 22-Jan-2016 12:52

You are not understanding. Read this http://www.linuxatemyram.com/.

Modern operating systems will strive to consume all available RAM. This is normal. However RAM assigned to file system cache is very low priority and is relinquished rapidly.

Don't believe me? Try this on a test box:

free -m

echo 3 | sudo tee /proc/sys/vm/drop_caches on

free -m

This instructs Linux to empty the file system cache and return the memory to "free".

Also see the presentation I gave a few years back at Progress Exchange: www.progress.com/.../Track-5---Understanding-Operating-System-Performance-Metrics.pdf

Posted by Paul Koufalis on 22-Jan-2016 12:58

Here I tried it for you on a test box. Look at how free changed.

BEFORE:

$ free -m
             total  used  free shared buffers cached
Mem:         32182 32023   159      0     442  27378
-/+ buffers/cache:  4202 27980
Swap:        33951     0 33951

AFTER:

             total  used  free shared buffers cached
Mem:         32182 17193 14989      0       0  13450
-/+ buffers/cache:  3741 28440
Swap:        33951     0 33951

 

Posted by durgaprasad m on 22-Jan-2016 13:10

Hi Paul,

Yes Understood now.

Thanks for testing paul

This thread is closed