Re: Physical Logging performance

R'diger M'hl wrote: > Good morning everybody, > > some time ago, I found the tip, that the pages/io should be > less than the bufsize (around 75%). Is that true? Certainly 75% is a good place to be. A lot less than that and you are wasting resources. A lot more than that and you have potential for performance improvement. Usually the resources you are wasting (as with your logical log buffer) are not significant enough to reallocated else where. > I had a physical bufsize of 16 and always a pages/io of > around 15.7 so I increased the bufsize to now 32, but > it still shows a high number. > Do I need to increase even more? Yes, in general keep increasing until it starts to drop towards around 75%. Remember though that this is a cache, and if the system goes down you lose your cache. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list