IDS Forum

Re: Maxlen exceed 25

Posted By:
Date:

Our database is sitting on a NetApp, therefore I don't
think fragmentation is going to make any difference.

May be adding more AIO VPS will help. Is there any
rule of how many AIO VPs should I add. I know the rule
that Informix recommends is 1 AIO VP per chunk. But we
have already 18 AIO VPs for 9 chunks, which makes 2
AIO VPs per chunk.

Sorry, but what "counts" should I check from "onstat
-g ath"?Thanks,

Milena
--- Jack Parker <vze2qjg5@verizon.net> wrote:
> Add more AIOvps or fragment your data across more
> disks.
>
> onstat -g ath | grep aio to check count
> onmode -p +<n> aio to add (while online - otherwise
> edit $ONCONFIG)
>
> Your chunks 5, 6 and 8 are fairly hot, you could
> spread the load off of
> them.
>
> Let me guess, chunk 1 is rootdbs, chunk2 is log?
> Those are barely working
> up a sweat - BUT then all of this is in terms of
> logical disk, there may be
> something else going on underneath the covers.
>
> cheers
> j.
>
> (default .sig)
> If my note seems hurried, short, cross or (in the
> words of one young lady)
> 'hard-*ssed' it's probably because I am working with
> this cr*ppy mail
> program and have left my glasses downstairs
> somewhere and can't see what I'm
> typing - please don't take it personally. I
> probably didn't or couldn't
> read the entire email you sent.
> ----- Original Message -----
> From: "Milena Ilieva " <milena_ilieva@yahoo.com>
> To: <ids@iiug.org>
> Sent: Monday, February 10, 2003 1:40 PM
> Subject: Re: Maxlen exceed 25 [318]
>
>
> > Hi,
> >
> > I was going to ask the same question, because we
> have
> > much bigger numbers in the maxlens column:
> >
> > informix@vaprp1> onstat -g ioq|more
> >
> > Informix Dynamic Server Version 7.30.UC10 --
> On-Line
> > -- Up 3 days 21:30:25 --
> > 575576 Kbytes
> >
> > AIO I/O queues:
> > q name/id len maxlen totalops dskread dskwrite
> > dskcopy
> > adt 0 0 0 0 0 0
> > 0
> > msc 0 0 1 347132 0 0
> > 0
> > aio 0 0 16 341508 254473 2
> > 0
> > pio 0 0 1 47653 0 47653
> > 0
> > lio 0 0 1 920669 0 920669
> > 0
> > gfd 3 0 19 16773 4907 11866
> > 0
> > gfd 4 0 1 165592 165592 0
> > 0
> > gfd 5 0 174 406608 123179 283429
> > 0
> > gfd 6 0 233 2214357 1998582 215775
> > 0
> > gfd 7 0 1428 1892334 1711859 180475
> > 0
> > gfd 8 0 884 1819782 1643994 175788
> > 0
> > gfd 9 0 405 1719912 1594551 125361
> > 0
> > gfd 10 0 723 2251513 1954953 296560
> > 0
> > gfd 11 0 157 565028 430392 134636
> > 0
> >
> > What would you recommend in our case?
> >
> > Thanks,
> >
> > Milena
> > --- Madison Pruet <mpruet@us.ibm.com> wrote:
> > >
> > >
> > >
> > >
> > > I think that the 25 limit is the suggestion for
> > > using aiovps, not kaio.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > "FRANKLIN TANG"
> > >
> > >
> > > <franklin@macausl
> To:
> > > ids@iiug.org
> > >
> > > ot.com>
> cc:
> > >
> > >
> > > Sent by:
> > > Subject: Maxlen exceed 25 [306]
> > >
> > > forum.subscriber@
> > >
> > >
> > > iiug.org
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 02/10/2003 01:16
> > >
> > >
> > > AM
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi all,
> > > I use the onstat -g ioq and have the following
> > > information
> > > AIO I/O queues:
> > > q name/id len maxlen totalops dskread
> dskwrite
> > > dskcopy
> > > kio 0 0 64 245740605 243860239
> 1880366
> > > 0
> > > kio 1 0 64 225398151 223644673
> 1753478
> > > 0
> > > kio 2 0 39 153270901 151775269
> 1495632
> > > 0
> > > kio 3 0 62 108240810 106971733
> 1269077
> > > 0
> > > kio 4 0 33 16292989 15771773
> 521216
> > > 0
> > > kio 5 0 64 74956527 73902907
> 1053620
> > > 0
> > > kio 6 0 32 20469740 19905662
> 564078
> > > 0
> > > kio 7 0 32 52528564 51648496
> 880068
> > > 0
> > > kio 8 0 35 37053372 36308162
> 745210
> > > 0
> > > kio 9 0 61 27060908 26398981
> 661927
> > > 0
> > > kio 10 0 33 13736374 13249805
> 486569
> > > 0
> > > kio 11 0 32 12006058 11535554
> 470504
> > > 0
> > > adt 0 0 0 0 0
> 0
> > > 0
> > >
> > > From most doc, it is recommand that maxlen
> should
> > > not exceed 25. So what
> > > should i do now?? Could anyone give me more
> > > suggestion please
> > >
> > > Franklin
> > >
> > >
> > >
>
=== message truncated ===


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Messages In This Thread

• Maxlen exceed 25
  FRANKLIN TANG -- Monday, 10 February 2003, at 2:16 a.m.
  • Re: Maxlen exceed 25
    Mark D. Stock -- Monday, 10 February 2003, at 5:49 a.m.
  • Re: Maxlen exceed 25
    Madison Pruet -- Monday, 10 February 2003, at 10:17 a.m.
    • Re: Maxlen exceed 25
      Milena Ilieva -- Monday, 10 February 2003, at 1:40 p.m.
      • Re: Maxlen exceed 25
        Milena Ilieva -- Monday, 10 February 2003, at 5:10 p.m.
        • Re: Maxlen exceed 25
          Madison Pruet -- Monday, 10 February 2003, at 6:01 p.m.
          • Re: Maxlen exceed 25
            Mark D. Stock -- Tuesday, 11 February 2003, at 3:37 a.m.
          • RE: Sysmas ter - Tabe las Tempor iso-8859-1?QE1ria
            André Luiz Rufino -- Tuesday, 21 January 2014, at 5:25 a.m.
            • Re: Sysmas ter - Tabe las Tempor iso-8859-1?QE....
              Fernando Nunes -- Tuesday, 21 January 2014, at 6:07 a.m.
      • Re: Maxlen exceed 25
        Mark D. Stock -- Monday, 10 February 2003, at 6:18 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.