Re: changing size of logs

Personally I like about 100 logs and try to scale then so only 75% are used during the processing day. I have no strong reasons for doing this I just find it works well for me, but like every hard and fast rule it's often changed :-) My 2c Paul Watson ---------- From: Mark D. Stock To: Neil Truby Cc: informix-list@iiug.org Subject: Re: changing size of logs Date: 01 March 1999 08:06 Neil Truby wrote: > > Don't you think 1 megabyte logs is taking this a bit too far, though? In general I would agree. But it depends on the transaction activity and how quickly logs fill. It might take a day to fill a 5Mb log, so 1Mb could take an hour or so. The other consideration is log buffer size and logging mode. If log buffers are very large and all databases use buffered logging, then this could be the reason logs fill slowly. 2c. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+