RE: Buffwaits Ratio and Buffer Turnovers
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_000_01C07977.AEDA0CEE
Content-Type: text/plain;
charset="iso-8859-1"
Thanks again Art,
Okay the output from the program I've written to calculate the ratios you
mentioned looks like this :-
Days, 1 Hours, 28 Minutes, 45 Seconds
dskreads=5128253 pagreads=5324645 bufreads= 369010470 %read
cached=98.61
dskwrits=230342 pagwrits=465901 bufwrits=3934033 %writ
cached=94.14
bufwaits=589924 BR=6.37 BT=24.77 BTR=16.75 BTF mins=3.55 BTF
secs=214.94
Days, 1 Hours, 28 Minutes, 55 Seconds
dskreads=5130102 pagreads=5326667 bufreads= 369264488 %read
cached=98.61
dskwrits=230709 pagwrits=466752 bufwrits=3937367 %writ
cached=94.14
bufwaits=591725 BR=6.39 BT=24.79 BTR=16.73 BTF mins=3.55 BTF
secs=215.21
Days, 1 Hours, 29 Minutes, 5 Seconds
dskreads=5132301 pagreads=5329201 bufreads= 369906361 %read
cached=98.61
dskwrits=231024 pagwrits=467405 bufwrits=3941011 %writ
cached=94.14
bufwaits=593553 BR=6.40 BT=24.81 BTR=16.71 BTF mins=3.59 BTF
secs=215.47
Days, 1 Hours, 29 Minutes, 15 Seconds
dskreads=5133962 pagreads=5331087 bufreads= 370910522 %read
cached=98.62
dskwrits=231381 pagwrits=468027 bufwrits=3943944 %writ
cached=94.13
bufwaits=595340 BR=6.42 BT=24.82 BTR=16.68 BTF mins=3.59 BTF
secs=215.77
Days, 1 Hours, 29 Minutes, 25 Seconds
dskreads=5135861 pagreads=5333300 bufreads= 371768310 %read
cached=98.62
dskwrits=231776 pagwrits=468754 bufwrits=3961766 %writ
cached=94.15
bufwaits=597463 BR=6.43 BT=24.87 BTR=16.69 BTF mins=3.58 BTF
secs=215.70
I wondered if you had any initial comments on the output or any other areas
we should be looking at to monitor performance. Our current onconfig.live is
attached for information and comment should you so wish.
Yours
Earle A Long (Senior Informix DBA)
SINGLEPOINT LIMITED
-----Original Message-----
From: ART KAGEL, BLOOMBERG/ NEW YORK [mailto:KAGEL@bloomberg.net]
Sent: 05 January 2001 13:38
To: earle@btclick.com
Subject: Re: Buffwaits Ratio and Buffer Turnovers
The stats are cleared, obviously, at startup, after that if you have cleared
them since you can look at sysshmvals.sh_pfclrtime which is a UNIX time.
However, you do not need to translate that just use:
SELECT (sh_curtime - sh_pfclrtime) Secs_Since_Reset
FROM sysshmvals;
Art S. Kagel
----- Original Message -----
From: Earle A Long <earle@btclick.com>
At: 1/ 4 11:23
> Having now written a monitoring program for the ratios mentioned in Art's
> earlier emails we are currently running at a BR of 2.81. Any comments ??
>
> Regarding the Buffer Turnovers I've got as far as the BT calculation but
> nowhere can I find the time stats were last zeroed. Is this saved anywhere
> if so where ??
>
> Buffwaits Ratio
> BR=buffwaits*100/(pagreads+bufwrits)
>
> Buffer Turnovers (BT) = (pagreads + bufwrits) / BUFFERS
> BTR = BT / (#hours since stats were last zero'd out (ie onstat -z))
> BTF = (#minutes or seconds since stats zero'd) / BT
>
> --
> Earle A Long (Senior Informix DBA)
> SINGLEPOINT UK LTD
------_=_NextPart_000_01C07977.AEDA0CEE
Content-Type: application/octet-stream;
name="onconfig.live"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="onconfig.live"
#***********************************************************************=
***
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.live
# Description: INFORMIX-OnLine Configuration Parameters
#
#***********************************************************************=
***
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
# =20
# ** To be changed **ROOTPATH /usr/online/chunk1 # Path for device containing root =
dbspace
ROOTOFFSET 0 # Offset of root dbspace into device =
(Kbytes)
ROOTSIZE 200000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes =3D 1, No =3D 0)
MIRRORPATH =20
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS physdbs # Location (dbspace) of physical log
PHYSFILE 2000000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 12 # Number of logical log files
LOGSIZE 5000 # Logical log size (Kbytes)
# Diagnostics=20
MSGPATH /usr/informix/online.log # System message log file path
CONSOLE /usr/informix/console.log # System console message path
ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path
# System Archive Tape Device
TAPEDEV /dev/rmt2 # Tape device path=09
#TAPEDEV /dev/null # Tape device path=09
TAPEBLK 64000 # Tape block size (Kbytes)
TAPESIZE 140000000 # Maximum amount of data to put on tape =
(Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape =
(Kbytes)
# Optical
STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area=20
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine =instance
DBSERVERNAME online_4u # default database server
DBSERVERALIASES online_4u_sh # List of alternate dbservernames
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in =distributed env.
RESIDENT 0 # Forced residency flag (Yes =3D 1, No =
=3D 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for =multi-processor
NUMCPUVPS 5 # 3 Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps =to one
NOAGE 1 # Process aging
AFF_SPROC 1 # 0 Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 20000 # Maximum number of locks 20000
BUFFERS 373712 # Maximum number of shared buffers =50000
NUMAIOVPS 1 # 2 Number of IO vps 1
## *** Need to verify by looking at tbstat -l output and confirming that =
the
# pages/io figure for the physical log is less than 75% of the buffer =
size,
# if not then increase the physical log buffer size.
PHYSBUFF 1000 # Physical log buffer size (Kbytes)
LOGBUFF 1000 # Logical log buffer size (Kbytes)LOGSMAX 60 # Maximum number of logical log files
CLEANERS 127 # Num