Re: Thoughts on Logical Log use requested

It's in the admin guide, the section on disk usage and logical logs. It also says that only the used pages are written to disk, so no matter how big the log buffer is, the only wastage is a partial page and no where near the 75% estimate by TBP which is the point I was trying to make. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Obnoxio The Clown" <obnoxio@serendipita.com> >To: "Colin Dawson" <cjd_1955@hotmail.com> >CC: informix-list@iiug.org >Subject: Re: Thoughts on Logical Log use requested >Date: Fri, 17 Mar 2006 15:23:35 -0000 (GMT) > > >Colin Dawson said: > > i did that well before i asked the question. > > > > FYI (from the FM) > > It is recommended that you set LOGBUFF to 16 or 32 kilobytes, or perhaps > > 64 kilobytes for heavy workloads. > >The buffer gets flushed. > >The WHOLE buffer gets flushed. > >If the buffer is empty (as in your case), it flushes 32 pages, even though >only one of them is full. > >It *is* in the manual. Somewhere. > > >>From: "Obnoxio The Clown" <obnoxio@serendipita.com> > >> > >>Colin Dawson said: > >> > Surely whenever data is written to the log > >> > it > >> > does not write the unused portion of log buffer? > >> > >>RTFM. > >-- >Bye now, >Obnoxio > >"It's easier with pictures." > -- Cosmo > >"But wait, it gets worse." > -- Cosmo > >"Run, don't walk, for the nearest exit." > -- Cosmo >