IDS Forum

Re: RE: IDS 7.31 Solaris8 - Long Checkpoints

Posted By: Art Kagel
Date: Monday, 16 March 2009, at 12:35 p.m.

In Response To: RE: RE: IDS 7.31 Solaris8 - Long Checkpoints (kate)

I have to disagree with both of your suggestins Kate. Increasing buffers
will only increase the number of dirty buffers at checkpoint time making the
checkpoints even longer. Since the OP is using 7.31 he only has full
integer control of the LRU_MIN/MAX_DIRTY parameters, so 2/1 is as low as he
can go and changing the MIN from 2 to 1 will not help a whole lot if they
are increasing BUFFERS to boot. Now you may be right that the instance is
too small and they could use more buffers to make EVERYTHING run better and
faster, but that's not going to help the checkpoint duration at all.

Your the ideas in your other post I'll address there.

Art

On Mon, Mar 16, 2009 at 12:24 PM, kate <kate@iiug.org> wrote:

> No NJ, that would be changing too many things at once. Even Art has too
> many. For starters just change what I said, bounce you engine, and see what
> your results are.
>
> Changing buffers often causes a retune of the whole environment. I agree he
> could be using many more, but lets focus on the current problem first.
>
> Thanks!
> Kate Tomchik [ kate@iiug.org ] www.iiug.org
> International Informix Users Group Board of Directors
>
> A computer lets you make more mistakes faster than any invention in human
> history - with the possible exceptions of handguns and tequila.
> Mitch Ratliffe
>
> ---------- Original Message -----------
> From: "Norma Jean Sebastian" <nsebastian@flinnsci.com>
> To: ids@iiug.org
> Sent: Mon, 16 Mar 2009 11:56:55 -0400 (EDT)
> Subject: RE: RE: IDS 7.31 Solaris8 - Long Checkpoints [15154]
>
> > Kurt,
> > It's cool you're not taking more virtual memory segs to get the work
> > done (only 1 "V" in your onstat -g seg output).
> > Your engine is only sized to about 413MB, while you said you have
> > 4GB RAM on the server.
> >
> > In addition to Art Kagel's suggestion he just saw posted....
> > Try increasing your buffers... what else is running on the
> > server?... increasing buffers is the main thing that will increase
> > the size of your Informix engine... you're on a 7.31 (32bit) engine
> > ... you could max the Informix engine up to about 3.75GB I think...
> > you don't have to go for the full max, but at least double it to
> > about 1 GB instead of the 413MB you have now.
> >
> > Thanks,
> > Norma Jean Sebastian
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > Of KURT VAN GOMPEL Sent: Monday, March 16, 2009 10:36 AM To:
> > ids@iiug.org Subject: Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
> > [15149]
> >
> > Hello,
> >
> > Here's the output op onstat -g seg:
> >
> > Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 10:22:10 --
> > 412752 Kbytes
> >
> > Segment Summary:
> > id key addr size ovhd class blkused blkfree
> > 94000 1394493441 a000000 268435456 24820 R* 31026 1742
> > 94001 1394493442 1a000000 153600000 2948 V 9760 8990
> > 94002 1394493443 2327c000 622592 616 M 75 1
> > Total: - - 422658048 - - 40861 10733
> >
> > (* segment locked in memory)
> >
> > Hello,
> > We are running IDS7.31 UD1 on a Solaris8 server with 2 Sparc64
> > processors and 4GB RAM.
> > It is used for interactive and batch processing.
> > When lots of manipulations on the DB are done, it takes sometimes
> > more than 60 seconds to do his checkpoints. Some parameters of our
> > config file: MULTIPROCESSOR 1 NUMCPUVPS 2 SINGLE_CPU_VP 0 NOAGE 1
> > AFF_SPROC 0 AFF_NPROCS 0 LOCKS 700000 BUFFERS 100000 NUMAIOVPS 1
> > PHYSBUFF 64 LOGBUFF 64 LOGSMAX 600 CLEANERS 8 CKPTINTVL 120 LRUS 8
> > LRU_MAX_DIRTY 5 LRU_MIN_DIRTY 2 Any idea how to speed up the
> > checkpoints?
> >
> >
>
> *****************************************************************************
> ** Forum Note: Use "Reply" to post a response in the discussion forum.
> ------- End of Original Message -------
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.

--001636427251eb776a04653f08bd

Messages In This Thread

• IDS 7.31 Solaris8 - Long Checkpoints
  KURT VAN GOMPEL -- Monday, 16 March 2009, at 11:26 a.m.
  • RE: IDS 7.31 Solaris8 - Long Checkpoints
    Norma Jean Sebastian -- Monday, 16 March 2009, at 11:32 a.m.
    • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
      KURT VAN GOMPEL -- Monday, 16 March 2009, at 11:35 a.m.
      • RE: RE: IDS 7.31 Solaris8 - Long Checkpoints
        Norma Jean Sebastian -- Monday, 16 March 2009, at 11:56 a.m.
        • RE: RE: IDS 7.31 Solaris8 - Long Checkpoints
          kate -- Monday, 16 March 2009, at 12:24 p.m.
          • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
            Art Kagel -- Monday, 16 March 2009, at 12:35 p.m.
            • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
              kate -- Monday, 16 March 2009, at 12:46 p.m.
              • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                Art Kagel -- Monday, 16 March 2009, at 12:54 p.m.
                • RE: RE: IDS 7.31 Solaris8 - Long Checkpoints
                  Norma Jean Sebastian -- Monday, 16 March 2009, at 1:58 p.m.
                  • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                    Art Kagel -- Monday, 16 March 2009, at 3:19 p.m.
                    • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                      KURT VAN GOMPEL -- Monday, 16 March 2009, at 3:38 p.m.
                      • Re: IDS 7.31 Solaris8 - Long Checkpoints
                        tilleul17@web.de -- Monday, 16 March 2009, at 4:06 p.m.
                      • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                        Art Kagel -- Monday, 16 March 2009, at 6:56 p.m.
                        • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                          KURT VAN GOMPEL -- Tuesday, 17 March 2009, at 5:29 a.m.
                          • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                            Art Kagel -- Tuesday, 17 March 2009, at 10:28 a.m.
                            • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                              KURT VAN GOMPEL -- Tuesday, 24 March 2009, at 9:33 a.m.
                              • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                                Art Kagel -- Tuesday, 24 March 2009, at 10:34 a.m.
                                • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                                  PING TANG -- Tuesday, 24 March 2009, at 11:45 a.m.
                              • Re: RE: IDS 7.31 Solaris8 - Long Checkpoints
                                Art Kagel -- Tuesday, 24 March 2009, at 10:36 a.m.
  • Re: IDS 7.31 Solaris8 - Long Checkpoints
    Art Kagel -- Monday, 16 March 2009, at 11:51 a.m.
  • Re: IDS 7.31 Solaris8 - Long Checkpoints
    kate -- Monday, 16 March 2009, at 12:20 p.m.
    • Re: IDS 7.31 Solaris8 - Long Checkpoints
      Art Kagel -- Monday, 16 March 2009, at 12:42 p.m.
      • Re: IDS 7.31 Solaris8 - Long Checkpoints
        kate -- Monday, 16 March 2009, at 12:45 p.m.
  • Re: IDS 7.31 Solaris8 - Long Checkpoints
    kate -- Tuesday, 17 March 2009, at 9:43 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.