Re: Thoughts on Logical Log use requested

Admin Guide page 11-11 Section on Unbuffered transaction logging "When the database server flushes the buffer, only the used pages are written to disk. Used pages include pages that are only partially full, however, so some space is wasted. For this reason, the logical-log files on disk fill up faster than if all the databases on the same database server use buffered logging." 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:52:08 -0000 (GMT) > > >Colin Dawson said: > > 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. > >Where does it say this? > > >>From: "Obnoxio The Clown" <obnoxio@serendipita.com> > >> > >>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 >