Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Informix > Out of memory Suddently....

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-20-07, 07:46
dicipulofer dicipulofer is offline
Registered User
 
Join Date: Oct 2007
Posts: 35
Exclamation Out of memory Suddently....

Hello...

I'm worried with one problem...

My server's showing one message to me "Out of memory" and. when this happen, all database stop for somes seconds..


I wait somes seconds, and all turn normal...


I don't know what I do to discover what's happening with my database....

Someone have a idea to me check what's wrong ?
Reply With Quote
  #2 (permalink)  
Old 12-20-07, 08:33
dicipulofer dicipulofer is offline
Registered User
 
Join Date: Oct 2007
Posts: 35
Swap

I'm thinking it's problem due low swap memory...


total used free shared buffers cached
Mem: 2016 2001 15 0 5 970
-/+ buffers/cache: 1024 991
Swap: 2000 1513 150


when my server got close 100 free, the application stop !!


When the value increase to 400 free (swap value).... the server stay stable...

Att,
Fernando.
Reply With Quote
  #3 (permalink)  
Old 12-20-07, 12:43
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Distrito Federal - Brasil
Posts: 197
what version of your IDS?
What OS?
How much of Physical Memory you have in this machine?
How much of shared+resident memory config your IDS?
Do you have another heavy services running ?
Do you set the RESIDENT option on ONCONFIG?

Some commands, if your OS is Linux:
vmstat
swapon -s ## show status
swapoff -a ## disable swap
sar -r 1 1000
free
study about kernel parameters: /proc/sys/vm/*
man -S 5 proc
__________________
________________________________________
César Inacio Martins
Distrito Federal - Brasil
________________________________________
Reply With Quote
  #4 (permalink)  
Old 12-20-07, 15:21
dicipulofer dicipulofer is offline
Registered User
 
Join Date: Oct 2007
Posts: 35
IBM Informix Dynamic Server Version 9.40.UC3
Red Hat Enterprise
2 GB


# Shared Memory Parameters

LOCKS 2000 # Maximum number of locks
BUFFERS 5000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x44000000L # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 32


And.. I no have RESIDENT configured in my onconfig (is 0)


and no have other heavy application in this machine....

What do u think ?
Reply With Quote
  #5 (permalink)  
Old 12-20-07, 16:09
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Distrito Federal - Brasil
Posts: 197
This is a very strange!!!
Your sure don't have another application??

my suggestion to start:
- monitor your linux with command "top" to see what application are using more memory/cpu (press "h" to see the help, i don't remember now but have a option to order by memory utilization)
- check how much your IDS is using of memory :
onstat -
onstat -g seg
__________________
________________________________________
César Inacio Martins
Distrito Federal - Brasil
________________________________________
Reply With Quote
  #6 (permalink)  
Old 01-02-08, 14:29
dicipulofer dicipulofer is offline
Registered User
 
Join Date: Oct 2007
Posts: 35
Swap

I added more swap memory.. and the problem was "solved.."


now.. I need to find.. what process's taking a lot memory.. and using swap..



thanks for all
Fernando
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On