RE: Memory Usage

No, I meant the *UNIX* buffer cache, not the Informix one you see on 'onstat -p'. It's a kernel parameter called 'dbc_max_pct'. Paul Mosser -----Original Message----- From: Tony Flaherty [mailto:aef@mfs.misys.co.uk] Sent: Friday, September 29, 2000 4:42 AM To: informix-list@iiug.org Subject: Re: Memory Usage Yeh, from a previous post I was advised to increase BUFFERS, I'm running at cache rates of 97% read and 93% write at the moment. -- Tony Flaherty Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! MFS Ltd. mosserp@WellsFargo.COM wrote in message <8qre9b$dak$1@news.xmission.com>... > >Have you checked your unix Buffer Cache percentage (bcp)? I believe the >default is 50%, but I saw a recommendation from HP tech support that 20% is >generally sufficient. If you're still sitting at 50% -- that's up to 256Mb >eaten up already! Do you have "glance" installed? great tool for easily >monitoring memory usage, plus a lot of other stuff... > >HTH, >Paul Mosser > >-----Original Message----- >From: Tony Flaherty [mailto:aef@mfs.misys.co.uk] >Sent: Tuesday, September 26, 2000 4:31 AM >To: informix-list@iiug.org >Subject: Memory Usage > > > >HpUx 10.20 Dual Processor K200 512Mb RAM > >Informix Dynamic Server 7.30.UC7 > > >I want to allocate more memory to my Informix server, but I need some advice >on how to examine the current memory usage of the machine. > >The machine runs an OLTP Informix database with approx 100 users, both the >client and the server applications run on the same machine. > >I currently have 156Mb allocated as BUFFERS to IDS and I'd like to increase >this to 254Mb. I'm inclined to just do this as we ugraded the machine from >256Mb to 512Mb about a year ago, so even if I do allocate half of this to >IDS I've still got more left for the OS and Client apps than I had before, >but I'd like a more proffesional way of making this decision ;o) > >Some possible usefull info;- > >swapinfo > > Kb Kb Kb PCT START/ Kb >TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME >dev 524288 60252 464036 11% 0 - 1 /dev/vg00/lvol2 >dev 524288 61880 462408 12% 0 - 1 >/dev/vg04/lv_swap2 >reserve - 598300 -598300 >memory 397140 334560 62580 84% > > >sar -w > > >HP-UX hpk200 B.10.20 U 9000/819 09/26/00 > >00:00:00 swpin/s bswin/s swpot/s bswot/s pswch/s >01:00:00 0.99 0.0 0.99 0.0 1040 >02:00:00 1.00 0.0 1.00 0.0 687 >03:00:00 1.00 0.0 1.00 0.0 452 >04:00:00 1.00 0.0 1.00 0.0 77 >05:00:00 1.00 0.0 1.00 0.0 73 >06:00:00 1.00 0.0 1.00 0.0 415 >07:00:00 1.00 0.0 1.00 0.0 79 >08:00:00 1.00 0.0 1.00 0.0 77 >08:20:00 1.00 0.0 1.00 0.0 88 >08:40:00 1.00 0.0 1.00 0.0 240 >09:00:00 1.00 0.0 1.00 0.0 261 >09:20:00 0.99 0.0 1.02 0.1 717 >09:40:00 0.95 0.0 1.02 0.3 1286 >10:00:01 0.98 0.0 1.02 0.2 485 >10:20:01 0.99 0.0 1.01 0.3 555 >10:40:01 1.00 0.0 1.01 0.1 598 >11:00:00 0.99 0.0 1.00 0.1 469 >11:20:00 0.99 0.1 1.01 0.4 485 >11:40:00 0.98 0.0 1.00 0.2 574 >12:00:00 0.99 0.0 1.00 0.2 479 >12:20:00 1.00 0.1 0.98 0.1 450> >Average 1.00 0.0 1.00 0.1 416 > >onstat -g seg> > >Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 16:55:51 -- >298184 Kbytes > >Segment Summary: >id key addr size ovhd class blkused blkfree >777 1381451778 c0bda000 2711552 652 M 325 6 >776 1381451777 d1235000 202932224 5572 R* 24765 7 >(shared) 1381451777 dd3bd000 102408192 2172 V 7365 5136 >Total: - - 308051968 - - 32455 5149 > > (* segment locked in memory) > > > >If there's any other info you'd like to see please let me know. > >TIA >-- >Tony Flaherty >Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! >MFS Ltd. >

Yeh I know, I was replying to Neil Trubys post but suffered from hand-mouse-pointer inaccuracies :o( The dbc_max_pct is currently at 50% so thanks for the pointer, I'll investigate this further. -- Tony Flaherty Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! MFS Ltd. mosserp@WellsFargo.COM wrote in message <8r3bde$2cn$1@news.xmission.com>... > >No, I meant the *UNIX* buffer cache, not the Informix one you see on 'onstat >-p'. It's a kernel parameter called 'dbc_max_pct'. > >Paul Mosser > >-----Original Message----- >From: Tony Flaherty [mailto:aef@mfs.misys.co.uk] >Sent: Friday, September 29, 2000 4:42 AM >To: informix-list@iiug.org >Subject: Re: Memory Usage > > >Yeh, from a previous post I was advised to increase BUFFERS, I'm running at >cache rates of 97% read and 93% write at the moment. > >-- >Tony Flaherty >Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! >MFS Ltd. > >mosserp@WellsFargo.COM wrote in message <8qre9b$dak$1@news.xmission.com>... >> >>Have you checked your unix Buffer Cache percentage (bcp)? I believe the >>default is 50%, but I saw a recommendation from HP tech support that 20% is >>generally sufficient. If you're still sitting at 50% -- that's up to 256Mb >>eaten up already! Do you have "glance" installed? great tool for easily >>monitoring memory usage, plus a lot of other stuff... >> >>HTH, >>Paul Mosser >> >>-----Original Message----- >>From: Tony Flaherty [mailto:aef@mfs.misys.co.uk] >>Sent: Tuesday, September 26, 2000 4:31 AM >>To: informix-list@iiug.org >>Subject: Memory Usage >> >> >> >>HpUx 10.20 Dual Processor K200 512Mb RAM >> >>Informix Dynamic Server 7.30.UC7 >> >> >>I want to allocate more memory to my Informix server, but I need some >advice >>on how to examine the current memory usage of the machine. >> >>The machine runs an OLTP Informix database with approx 100 users, both the >>client and the server applications run on the same machine. >> >>I currently have 156Mb allocated as BUFFERS to IDS and I'd like to increase >>this to 254Mb. I'm inclined to just do this as we ugraded the machine from >>256Mb to 512Mb about a year ago, so even if I do allocate half of this to >>IDS I've still got more left for the OS and Client apps than I had before, >>but I'd like a more proffesional way of making this decision ;o) >> >>Some possible usefull info;- >> >>swapinfo >> >> Kb Kb Kb PCT START/ Kb >>TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME >>dev 524288 60252 464036 11% 0 - 1 /dev/vg00/lvol2 >>dev 524288 61880 462408 12% 0 - 1 >>/dev/vg04/lv_swap2 >>reserve - 598300 -598300 >>memory 397140 334560 62580 84% >> >> >>sar -w >> >> >>HP-UX hpk200 B.10.20 U 9000/819 09/26/00 >> >>00:00:00 swpin/s bswin/s swpot/s bswot/s pswch/s >>01:00:00 0.99 0.0 0.99 0.0 1040 >>02:00:00 1.00 0.0 1.00 0.0 687 >>03:00:00 1.00 0.0 1.00 0.0 452 >>04:00:00 1.00 0.0 1.00 0.0 77 >>05:00:00 1.00 0.0 1.00 0.0 73 >>06:00:00 1.00 0.0 1.00 0.0 415 >>07:00:00 1.00 0.0 1.00 0.0 79 >>08:00:00 1.00 0.0 1.00 0.0 77 >>08:20:00 1.00 0.0 1.00 0.0 88 >>08:40:00 1.00 0.0 1.00 0.0 240 >>09:00:00 1.00 0.0 1.00 0.0 261 >>09:20:00 0.99 0.0 1.02 0.1 717 >>09:40:00 0.95 0.0 1.02 0.3 1286 >>10:00:01 0.98 0.0 1.02 0.2 485 >>10:20:01 0.99 0.0 1.01 0.3 555 >>10:40:01 1.00 0.0 1.01 0.1 598 >>11:00:00 0.99 0.0 1.00 0.1 469 >>11:20:00 0.99 0.1 1.01 0.4 485 >>11:40:00 0.98 0.0 1.00 0.2 574 >>12:00:00 0.99 0.0 1.00 0.2 479 >>12:20:00 1.00 0.1 0.98 0.1 450>> >>Average 1.00 0.0 1.00 0.1 416 >> >>onstat -g seg>> >> >>Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 16:55:51 -- >>298184 Kbytes >> >>Segment Summary: >>id key addr size ovhd class blkused blkfree >>777 1381451778 c0bda000 2711552 652 M 325 6 >>776 1381451777 d1235000 202932224 5572 R* 24765 7 >>(shared) 1381451777 dd3bd000 102408192 2172 V 7365 5136 >>Total: - - 308051968 - - 32455 5149 >> >> (* segment locked in memory) >> >> >> >>If there's any other info you'd like to see please let me know. >> >>TIA >>-- >>Tony Flaherty >>Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! >>MFS Ltd. >>