buffered logging

Posted in 2004

Topics: Performance & Tuning, Logging & Checkpoints

rkusenet — Thu, 24 Jun 2004 09:48:48 -0400 — source: Usenet: comp.databases.informix

I have never used buffered logging. Has anyone used it. Has anyone benchmarked the performance gain over unbuffered logging (my choice always). Also what should be the ideal LOGBUFF value to ensure that the logical log buffer gets flushed within a reasonable period of time, say a minute. As I understand there is no command to force the flushing of logical log buffer to the disk,right? Thanks.

↪ replying to rkusenet

Enor P — Thu, 24 Jun 2004 15:56:08 +0100 — source: Usenet: comp.databases.informix

rkusenet wrote: > I have never used buffered logging. Has anyone used it. > Has anyone benchmarked the performance gain over unbuffered > logging (my choice always). > Also what should be the ideal LOGBUFF value to ensure that > the logical log buffer gets flushed within a reasonable > period of time, say a minute. As I understand there is > no command to force the flushing of logical log buffer > to the disk,right? Am think if systme is very busy with update, can be 20 %. LOGBUF can be small, am I done my test with only 32K and many insert. Did not change LOGBUF even. Am think chekpoint will flush log buffer, so onmode -c will work? -- Enor

Glossary

logical log