Re: Thoughts on Logical Log use requested
Posted in 2006
Hi, that is no problem. Assuming you do backup your logs the only thing you need to be concerned with is that the backup of the logs can keep up with the logs filling. If log backup falls too much behind (e.g. 40 or 60 log files behind), then there is a chance that during a high peak activity phase you'd run into a logs-full situation. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management informix-list-bounces@iiug.org wrote on 13.03.2006 14:16:15: > Informix 7.31.FD7 > Solaris 9 > Logical Logs 80 * 100Mb, spread across 4 dbspaces, consecutive logs do not > reside in the same dbspace. > > > During busy periods the logical logs on my production system can fill in > minutes sometime this is can be < 1 minute > > Does this matter? > What effect is this likely to have on the DB? > > My own thoughts are that it is no big deal except that at the time a log > switch occurs I would get a small (milliseconds?) delay. I rarely see any > threads waiting for log buffers. > > Regards > > Colin > > There are 10 types of people in the world, those that understand binary and > those that don't > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list