Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <567b4m$jt5@cssun.mathcs.emory.edu>, "S. Hanson"
<scott@tiga.worldaccess.nl> writes
>Hello,
>
>I have a small question concerning the size of the physical log.
>According to the Online v5 Adm. Guide the size of the physical log should
>be created from
>
>"..is that total disk space allocated to the physical log and the logical log
>files should equal about 20 percent of all dbspace dedicated to Online. The
>ratio of logical log space to physical log space should be about 3:1."
>
Correct.
>But the v7.2 Adm. Guide says theat the Physical log size should be
>calculated from
>
>userthreads * (max_log_pages_per_critical_section) * 4
>
Correct.
>These two calculations give VERY different results on one of our machines
>(197000KB vs 4340KB).
>
>Can anyone help?
>
>Thanks,
>
>Scott Hanson
>
I've users relatively large systems (up to 28Gb), With only 20Mb of
physical log. On my Online 7 Tuning course the tutor did mention a very
large site (several hundred gigabytes) which uses 2Gb for logical logs,
physical logs tend to be smaller.
Try 20Mb and monitor it.
--
David Williams
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.