Re: Best Tune for Online 5.02

SailF3 wrote: > > What are the thoughts of a 40 and 50% for the high water - fells safer > to me. > > Sean Bradley I have been preaching 40% and 45% for the high-water marks. I think it should be mathematically provable that if you do continuous log backups, you would never experience a full logs problem, even if you have two or more rogue transactions. The second (and other) rogue will freeze as soon as the first rogue hits the 45% mark and can do no more damage for a while. By the time the first rogue is rolled back and the second rogue can continue, there is either free log space to roll back into (because it was backed up already; only the rogue[1] prevented it re-use) or that free space is imminently available as the logs gets backed up and their space freed for reuse. -- -- Jake (In persuit of undomesticated aquatic avians) +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+