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..........
You have 44 Gb free.
"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.
Hi libor,
As I mentioned that is yesterday memory value.today it reached 50gb.
Thanks....
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
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
Hi Paul,
Yes Understood now.
Thanks for testing paul