If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > IDS tunning processor

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-24-04, 12:34
kabedoya kabedoya is offline
Registered User
 
Join Date: Aug 2004
Posts: 2
IDS tunning processor

Hi!

I have IDS 7.31.UD2
some times the system is very slow. I use top command and oninit use 99.9% of processor and memory is only 7,6.

What parameters can i modify in onconfig file to tunning the processor use?


tanks in advantage.


kabedoya

top command answer:

11:19am up 3:03, 13 users, load average: 3,59, 3,55, 3,31
131 processes: 127 sleeping, 4 running, 0 zombie, 0 stopped
CPU0 states: 73,4% user, 15,2% system, 0,0% nice, 10,3% idle
CPU1 states: 57,0% user, 20,0% system, 0,0% nice, 22,3% idle
CPU2 states: 72,3% user, 16,4% system, 0,0% nice, 10,2% idle
CPU3 states: 65,5% user, 14,4% system, 0,0% nice, 19,0% idle
Mem: 3992848K av, 851296K used, 3141552K free, 309100K shrd, 80952K buff
Swap: 522072K av, 0K used, 522072K free 324296K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
22467 root 18 0 297M 297M 297M R 99,9 7,6 16:45 oninit
23618 root 16 0 1100 1100 836 R 4,2 0,0 1:49 top
15748 postgres 15 0 11248 10M 10532 R 3,8 0,2 0:00 postmaster
15747 postgres 13 0 11256 10M 10532 S 3,4 0,2 0:00 postmaster
15749 postgres 12 0 11224 10M 10528 R 3,2 0,2 0:00 postmaster
1852 nobody 9 0 4120 4120 3252 S 2,1 0,1 1:03 httpd


onstat -p command answer:
Informix Dynamic Server Version 7.31.UD2 -- On-Line -- Up 00:52:18 -- 606168 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
153831 226742 153351621 99.90 5564 9726 42094 86.78

isamtot open start read write rewrite delete commit rollbk
75523755 10218 12418 75407455 31998 72 89 1339 4

gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0

ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 1464.39 13.28 10 20

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
36846 0 158629637 0 0 0 39 480

ixda-RA idx-RA da-RA RA-pgsused lchwaits
5576 24 144154 149746 64
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

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