Logical Log Sizing

Posted in 1998

Stewart & Bronwyn Hague — 27 Jul 1998 07:14:32 GMT — source: Informix-list mailing list archive (1991-1998)

We are using Online 5.06.UC1. When we first set up the database we made a decision to use a large number of small logs (256 K) so they were frequently written to tape. We are now finding we are getting some long transactions. We are probably looking to re-initialize with a new log size of 2Mb (or possibly more), does anyone have any opinions/experience with logs of this size or greater. Any feedback will be appreciated.