Re: Thoughts on Logical Log use requested
Will reducing LOGBUFF really reduce log usage by 75% ? or will just reduce
the log buffer wastage by 75%. Surely whenever data is written to the log it
does not write the unused portion of log buffer?
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: TBP <TheBigPotato@NotHere.Co.Uk>
>To: informix-list@iiug.org
>Subject: Re: Thoughts on Logical Log use requested
>Date: Wed, 15 Mar 2006 11:51:24 GMT
>
>Obnoxio The Clown wrote:
> > Colin Dawson said:
> >> Logical Logging
> >> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> >> L-2 0 64 32440954 3833640 3636418 8.5 1.1
> >
> > Decrease the size of your logical log buffer to the minimum value
>allowed,
> > or just above it.
> >
>:P
>
>1.1 Pages used per I/O and an I/O is 32 Pages, so about 30.9 pages are
>"empty" :0
>
>So ... shutting down LOGBUFF to 16k will reduce your log usage by a
>remarkable 75%.
>
>However, before doing this I would try and establish how much your
>average pages/io is during your busy period. You do not want to fill up
>your LOGBUFF.
>
>So, onstat -z, busy busy busy, check onstat -l pages/io and then set
>your LOGBUFF to a nice value which is bigger than your average.
>
>Mash it up Harry!!!
>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list