Forum Post: RE: What is the best configuration for OE 10.2B Database?

Status
Not open for further replies.
C

ChUIMonster

Guest
31,978 [2014/08/29@03:18:40.108-0400] P-3556 T-3416 I BROKER 0: (-----) Server network message wait time (-Nmsgwait): 2 31,979 [2014/08/29@03:18:40.109-0400] P-3556 T-3416 I BROKER 0: (-----) Delay first prefetch message (-prefetchDelay): Disabled 31,980 [2014/08/29@03:18:40.110-0400] P-3556 T-3416 I BROKER 0: (-----) Prefetch message fill percentage (-prefetchFactor): 0 31,981 [2014/08/29@03:18:40.110-0400] P-3556 T-3416 I BROKER 0: (-----) Minimum records in prefetch ms (-prefetchNumRecs): 16 31,982 [2014/08/29@03:18:40.111-0400] P-3556 T-3416 I BROKER 0: (-----) Suspension queue poll priority (-prefetchPriority): 0 These are new with 10.2B06 and they relate to fetching data -- so probably not related to committing transactions unless your user is misleading you. If there is a chance that the real problem is that "transaction" includes fetching a bunch of data then set: -Mm 8192 -prefetchDelay -prefetchFactor 100 -prefetchNumRecs 200 (Use "otherargs" in the properties file.) Also enable "jumbo frames" in all of the networking infrastructure. Also enable after-imaging. Just because it is a workgroup license doesn't mean that you should not be using after imaging.

Continue reading...
 
Status
Not open for further replies.
Top