RE: How to calculate the buffer wait ratio?

Posted in 2000

JasonYLPang@pg.SLR.com — Thu, 27 Jul 2000 12:10:43 +0800 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFF780.A215CAF8 Content-Type: text/plain; charset="iso-8859-1" Thanks a lot for the scripts...It's really make my life easy...I think most of the CDI folks is waiting for your complete script. Again, Thank you very much. Regards, Jason -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Thursday, July 27, 2000 2:41 AM To: informix-list@iiug.org Subject: Re: How to calculate the buffer wait ratio? Great script, well crafted. I especially love the perl style associative array. I would make three suggestions: 1) add the 'onstat -p | ' to the beginning of the script 2) include the comments about acceptable values in the END{} printout, I did when I installed your script in production. 3) Sign it, add a README or some comments at the top, and submit it officially to the IIUG Repository by emailing it to: software@iiug.org and Walt will install it in the Repository. Art S. Kagel Marat wrote: > > It's from previous posting. It's very helpful for me. And I won't tire to say > my thanks to the authors. > > Ok - a contribution to all the helpful CDI folks. The following Awk > script will show you the UR (read-ahead utilization ratio) and the BR > (bufwaits ratio). Art Kagel gets all the credit for the formulas - I > just got sick of using my calculator. > ---------------------------------------- > awk ' > /[a-zA-Z]/ { > for(i=1; i<=NF; i++){ > name[i] = $i; > } > } > /[0-9]/ { > for(i=1; i<=NF; i++){ > content[name[i]] = $i; > } > } > END { > ixdaRA = content["ixda-RA"]; > idxRA = content["idx-RA"]; > daRA = content["da-RA"]; > RApgsused = content["RA-pgsused"]; > print "Read Utilization (UR): ", ((ixdaRA + idxRA + daRA) / > RApgsused) * 100, "%"; > > bufwaits = content["bufwaits"]; > bufwrits = content["bufwrits"]; > pagreads = content["pagreads"]; > print "Bufwaits Ratio(BR): ", ((bufwaits/(pagreads + bufwrits)) * > 100), "%"; > } > ' > ---------------------------------------------------------- > The UR should ideally be VERY near 100% - the higher the better. > The BR should be below 7% - the lower the better. > Check CDI archives for more info. > > JasonYLPang@pg.SLR.com wrote: > > > This message is in MIME format. Since your mail reader does not understand > > this format, some or all of this message may not be legible. > > > > ------_=_NextPart_001_01BFF6B2.12B03494 > > Content-Type: text/plain; > > charset="iso-8859-1" > > > > Hi all, > > > > I'm a newbie here...can anyone out there teach me how to calculate the > > bufwaits ratio based on the output of onstat -p? > > > > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 2 days 18:20:25 > > -- 1686080 Kbytes > > > > Profile > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > > 337544121 22939961 1286467833 73.76 28977960 20018155 356806201 91.88 > > > > isamtot open start read write rewrite delete commit > > rollbk > > 2962803697 50018416 637440143 380886011 160748285 90253778 13290496 26197003 > > 1045675 > > > > 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 1023616.34 54671.99 784 1568 > > > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > > 66639943 1282 618021591 24 0 9252 1324794 12935294 > > > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > > 168610454 13181361 80669720 261997622 144597997 > > > > Thanks/Regards, > > Jason > > > > ------_=_NextPart_001_01BFF6B2.12B03494 > > Content-Type: text/html; > > charset="iso-8859-1" > > Content-Transfer-Encoding: quoted-printable > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > > <HTML> > > <HEAD> > > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > > charset=3Diso-8859-1"> > > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > > 5.5.2650.12"> > > <TITLE>How to calculate the buffer wait ratio?</TITLE> > > </HEAD> > > <BODY> > > > > Hi all, > > > > > > I'm a newbie here...can anyone out = > > there teach me how to calculate the bufwaits ratio based on the output = > > of onstat -p? > > > > > > Informix Dynamic Server Version = > > 7.30.UC5   -- On-Line -- Up 2 days 18:20:25 -- 1686080 = > > Kbytes > > > > > > Profile > > dskreads pagreads bufreads %cached = > > dskwrits pagwrits bufwrits %cached > > 337544121 22939961 1286467833 = > > 73.76   28977960 20018155 356806201 91.88  > > > > > > isamtot  = > > open     start    = > > read     write    rewrite  = > > delete   commit   rollbk > > 2962803697 50018416 637440143 = > > 380886011 160748285 90253778 13290496 26197003 1045675 > > > > > > gp_read  gp_write gp_rewrt = > > gp_del   gp_alloc gp_free  gp_curs > > > FACE=3D"Courier">0        = > > 0        = > > 0        = > > 0        = > > 0        = > > 0        = > > 0       > > > > > > ovlock   ovuserthread = > > ovbuff   usercpu  syscpu   numckpts flushes = > > > > > FACE=3D"Courier">0        = > > 0            = > > 0        1023616.34 54671.99 = > > 784      1568    > > > > > > bufwaits lokwaits lockreqs = > > deadlks  dltouts  ckp

↪ replying to JasonYLPang@pg.SLR.com

Manel Falc� i Aige — Thu, 27 Jul 2000 08:42:51 GMT — source: Informix-list mailing list archive (1991-1998)

Great !. finally, what's its "official" name ?

RE: How to calculate the buffer wait ratio?

Related threads

Your privacy choices