Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?

Thanks, for the replies. I'll post the Informix case number tomorrow. I had the buffers set as high as 138000. The machine has 1GB of memory. I lowered them according to the recommendations in the "Informix Online Dynamic Server Handbook". My cache hit rate is right around 97%. The box has 4-64 bit 180 MHz PA-RISC chips. I've tried taking the number of CPU-VPS from 3 to 4 to 5. The ready queue does get smaller, but it still builds. Thanks and keep the hints coming... JMF rick.martino@ibm.net wrote in article <1kV2rKSxbLgw-pn2-mddnpqg3z1hk@rick200>... > On Sat, 4 Oct 1997 17:48:18, "James Francis" <jfrancis@dxi.com> wrote: > > > Hello, > > > > Here is the problem... > > > > We have an HP-K460 server running HP-UX 10.20 attached to an EMC high-speed > > disk array. > > Our database is around 100GB. > > > > When we run our application with one user everything performs lightning > > fast. > > As more users degrade, the performance continues to degrade. > > > > The relevant parameters from the onconfig file: > > MULTIPROCESSOR 1 > > NUMCPUVPS 3 > > NETTYPE ipcshm,2,300,CPU > > NETTYPE soctcp,1,100 ,NET > > BUFFERS 7200> > PDQPRIORITY 0 > > OPTCOMPIND 0> > > > We used sql explain to analyze each query and every one (we are averaging > > 24 queries in 30 seconds) > > is using an index lookup. There are no sequential scans. > > > > I have about 4 weeks in now, and have adjusted every parameter known to > > man, (well maybe not man, but at > > least Informix). Here is some onstat output that bothers me: > > onstat -g rea shows consistently around 10 entries. > > onstat -p shows a high number of bufwaits and lchwaits> > > > I have added more cpuvps, changed connection types, and on and on. > > > > Informix Tech Support has been of little help. Basically, we need to > > support 200 users and a processor per > > user is not an option:-) > > > > Any help is appreciated... > > > > Thanks, > > James Francis > > > > How many CPUs does the box have and how much RAM do you have to play > with and what is your cache hit percent with the settings above? > > I am in the process of setting up a K460x4 and am using similar > parameters, but is BUFFERS 7200 a typo, because I was planning on > starting with 100,000 and going from there. > > > rick > > > >