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

In article <1kV2rKSxbLgw-pn2-mddnpqg3z1hk@rick200>, rick.martino@ibm.net writes >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 > > > OK, Hardware questions ------------------ How many CPUs do you have? How many disk? How large are they? How many disk controllers do you have and how do they map to disks? UNIX questions -------------- Are you using raw partitions? Are you using an LVM (Logical Volume Manager? How many disk buffers do you have configured and how large are they? What does ps -ef (or ps -aux) give? Informix questions ------------------- What does onstat -a give? Is CPU affine 'pinning' supported on your platform? Is KAIO supported on your platform? -- David Williams