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

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