Re: Informix Optimization

On 1 Dec 98, at 18:18, Tony Marasco wrote: > We are currently running Online 5.10 with a quad-processor (133Mhz) > Intel box on UNIX. We plan on migrating to 7.x some time > in the near future. > > I am concerned about performance as we were told Informix 5.x > will not take advantage of more than one processor. Is this > true? Not quite. However, OL5 is more dependent on the OS for proper multi processing, whereas "OL7" can take more direct advantage of >1 CPU. > Our system idle time today was at 85%. My reaction is we need > to: a) buy faster hardware; b) separate the database engine from > the "main" UNIX box via networking. I suggested this and it > was not received well. Any comments? Users complain (and > I agree) that the system normally is running slowly. Idle time is 85% and you want to buy faster hardware? You're only using 15% of your CPUs and you want to buy faster hardware? Separating the server component from normal UNIX ops is a good idea, but you _really_ need to make sure that the link between the servers is good and very fast. > I included a copy of my TBMONITOR status report because I'm > curious to see how well our machine is tuned. Any comments? > Currently we have about 30% of our total user-base migrated > so I expect these numbers to increase three-fold. > > Thanks! > RSAM Version 5.10.UC1 -- On-Line -- Up 15:03:09 -- 4752 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 706591 1262633 37344263 98.11 109928 156115 588641 81.33 > > isamtot open start read write rewrite delete commit > rollbk 37591396 1115171 3204603 14484251 107629 119811 11399 > 2861680 152 > > ovtbls ovlock ovuser ovbuff usercpu syscpu numckpts flushes 0 > 0 0 0 4110.25 1085.89 126 349 > > bufwaits lokwaits lockreqs deadlks dltouts lchwaits ckpwaits compress 37 > 2 31590593 0 0 5355 32 25798 > You might want to add a few more buffers, your %write cache is a bit low. A copy of your TBCONFIG file might be useful. HTH. -- Ciao, Billy A neutron goes into a bar and asks the bartender, "How much for a beer?" The bartender replies, "For you, no charge."