RE: Slow trigger in cluster-environment

Pentti, Just want to let you know that you are not the only one who thinks the MC/ServiceGuard software may add significant overhead. We have Informix 7.31.FC2 running on a two-node HP K 580 cluster in a failover mode. We hade some problems a couple of weeks ago with the cluster and networks so we brought up the primary box as a standalone. For the first week, the box seemed much faster - lower system calls, lower run queue. Our main process had one of it's key transactions drop from an average of 2.3 seconds per transaction to around 1.8 seconds. Now that we have been up for 2 weeks, the transaction time is back up to 2.2 seconds, the run queue is back up as well as the system calls. The only thing that still seems much faster is doing a netstat -i or -r. It was always painfully slow with the cluster active now it is almost instant. The users are reluctant to go back to the cluster, other than some key benefits. Kirk Waterhouse UNIX Systems/PeopleSoft/Database Administrator CIBA Vision IS Department Phone:678-415-3177 Cell :404-783-3177 Fax :678-415-2714 kirk.waterhouse@cibavision.novartis.com > > > > >===== Original Message From "Pentti Tiet'v'inen" <pat@sci.fi> ===== > > >I'm trying to keep a column up to date in NT-box from HP-UX using a > trigger > > > > > >create trigger updalo> > >update of al_vara on alotmnt > > >referencing new as post > > >for each row(update eestin@web_consy:alotmnt > > >set al_vara = post.al_vara > > >where al_serial=post.al_serial > > >) > > > > > >This is working reasonably well when the Unix side is running in one > > >machine. Tests shows about 100 updates per second. > > >When the Unix side is a cluster having two HP-9000 connected together > same > > >trigger works about 20 times slower !!! > > >I've two cluster-configurations having same problem. > > > > > >Any ideas how to start tracking down the problem? > > >Thanks > > >Pentti > > > > ------------------------------------------------------------ > > This e-mail has been sent to you courtesy of OperaMail, as a free > service from > > Opera Software, makers of the award-winning Web Browser, Opera. Visit > us at > > http://www.opera.com/ or our portal at: http://www.myopera.com/ Your > free e-mail > > account is waiting at: http://www.operamail.com/ > > ------------------------------------------------------------