Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Tam McLaughlin — — source: Informix-list mailing list archive (1991-1998)
I posted a msg recently about long checkpoints and got some excellent advice
which included increasing buffers. The thing is more buffers = more RAM. My
system
is starting to use swap space and I guess to get over this we require more
RAM. Our
system is as follows:
Informix IDS 7.30.UC2
SCO UnixWare 7.0.1
Compaq proliant 6000 with ~ 25Gb HD RAD 5
3 pentium pro processors and 256 Mb Ram.
onstat -p shows:
Informix .... Version 7.30.UC2 -- On-Line -- Up 18:40:04 -- 131256 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits
%cached
24325046 3807141 1220385102 98.01 282842 521123 4544784 93.78
With 50k buffers and from what I have learned, it looks like we are going
through all
our buffers in 15 mins. So would I be correct in saying that as IDS works
totally different from
online with the threads etc etc etc ... more RAM is required and that it is
common practice to
upgrade the RAM as the engine will need to work harder than online 5 or
possibly even/also
that as I have allocated more buffers than previously, we are not seing the
performance benefits
as the system is starting to swap?
↪ replying to Tam McLaughlin
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <851rgn$oim$1@plutonium.btinternet.com>, Tam McLaughlin
<tamm@scotlegal.com> writes
>I posted a msg recently about long checkpoints and got some excellent advice
>which included increasing buffers. The thing is more buffers = more RAM. My
>system
>is starting to use swap space and I guess to get over this we require more
>RAM. Our
>system is as follows:
>
>Informix IDS 7.30.UC2
>SCO UnixWare 7.0.1
>Compaq proliant 6000 with ~ 25Gb HD RAD 5
>3 pentium pro processors and 256 Mb Ram.
>
>onstat -p shows:>
>Informix .... Version 7.30.UC2 -- On-Line -- Up 18:40:04 -- 131256 Kbytes
>Profile
>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits
>%cached
>24325046 3807141 1220385102 98.01 282842 521123 4544784 93.78
>
>With 50k buffers and from what I have learned, it looks like we are going
>through all
>our buffers in 15 mins. So would I be correct in saying that as IDS works
>totally different from
>online with the threads etc etc etc ... more RAM is required and that it is
>common practice to
>upgrade the RAM as the engine will need to work harder than online 5 or
>possibly even/also
>that as I have allocated more buffers than previously, we are not seing the
>performance benefits
>as the system is starting to swap?
>
>
>
reduce bufreads. Check applications are using indexes
(SET EXPLAIN ON) also update stats using dostats from
www.iiug.org -> Software -> utils2_ak
--
David Williams
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.