Re: Peformance degradation

Posted in 1996

Billy Wheeler — 9 Mar 1996 15:23:13 -0500 — source: Informix-list mailing list archive (1991-1998)

At 10:19 AM 3/8/96 +0100, Dutch BGC on-site support wrote: >On Thu, 7 Mar 1996, Tom Hogarty wrote: > >> I would be interested in seeing some of your >> tbconfig, in particular I'd like to know how long your checkpoints are taking. > > We recently changed our checkpoints from 1800 (30 m) to 500 (8 1/3 m). I think Tom's looking for the time a checkpoint takes to complete, not how long between checkpoints. The info will be in your online.log. > Unfortunately, the original DBA (DataBase 'Acker) chose to use the rootdbs > for everything. Aaaaaghghghghgh!!!!! (Unanimous chorus, I suspect! :) You need to move data into different DBSPACEs, logs into yet other DBPACES and take control of the disk layout. Try to ensure that each DBSPACE is on a separate physical disk. Try moving heavily hit tables into their own DBSPACEs. If you're on v7, try to set up TEMP DBSPACEs and investigate table fragmentation. So, apart from anything else, you should re-layout your disks under the LVM. Ouch. With my sincerest sympathy.