RE: Adding additional Listener ports

Disagree, if you have a largish number of users that need to log in a a relatively short period ie 1000 in five minutes then have multiple listeners on a single card does help. If you watch the q-exceed in onstat -g nt? then it tends to have an entry typically around th 10-100,but if you see it go off the scale ie > 1000 then adding additional listeners definitely helps. I have no idea what causes q-exceed to increment, and I've never got an answer from ITS. > -----Original Message----- > From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk] > Sent: Wednesday, August 02, 2000 11:43 > To: gary child > Cc: informix-list@iiug.org > Subject: Re: Adding additional Listener ports > > > gary child wrote: > > > > It has been suggested to me that adding additional Listener > ports to /etc/services > > and corresponding aliases to sqlhosts may provide a > performance gain by spreading > > user connectivity between the multiple listener ports. We > run 7.31.UC5 on > > HPUX11 and all connections via tcp. > > We do not use shared memory connections because we are > utilising HP Shmem_magic > > to address additional shared memory. > > Hang on, are you saying you are using TCP for local connections? Why > don't you use stream pipes? Adding multiple listeners is only really > useful if you have multiple network cards. I don't think you are going > to see much gain with local connections unless you have > 1000's of users. > > > I don't recall ever seeing anyone suggest > > multiple listener ports as a tuning option so I'd be interested to > > hear your thoughts. > > It is certainly a concept covered in the Sys Adm training course. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-- > ---------+ > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk > |//////// /| > | http://www.informix.com http://www.informixhandbook.com > |///// / //| > | http://www.iiug.org > +-----------------------------------+//// / ///| > | |This email will self-destruct in > |/// / ////| > | |10 sec. If you received this email > |// / /////| > | |in error, sorry about the mess. |/ > ////////| > +----------------------+-----------------------------------+-- > ---------+ >

"Watson, Paul" wrote: > Disagree, if you have a largish number of users that need to log in a > a relatively short period ie 1000 in five minutes then have multiple > listeners on a single card does help. If you watch the q-exceed in > onstat -g nt? then it tends to have an entry typically around th 10-100,> but if you see it go off the scale ie > 1000 then adding additional > listeners definitely helps. > I have no idea what causes q-exceed to increment, and I've never got > an answer from ITS. Hi, with later versions of the server administration manual there should be a better explanation with respect to q-exceed. In any case, there is a short paragraph on q-exceed in the MaxConnect manual (page 5-10 in http://www.informix.com/answers/english/docs/10maxcon/6678.pdf ): "q-exceed: the number of times that the threshold for the shared network free-buffer pool was exceeded. In most cases, the value in this columns should be 0 ..." q-exceeds > 0 usually is an indication that there isn't enough memory reserved for the networking subsystem - which doesn't cause any functional problems put will have some impact on performance. Memory can be tuned using the NETTYPE parameter in ONCONFIG (bottom of page 5-9 of the MaxConnect guide). Anyway, additional listeners do provide better performance if you have situations where hundreds of clients connect in a short period of time - but if you have hundreds of connections you should be looking into MaxConnect anyway, which would provide both better connect performance and better throughput in general. Hope this helps, Heiko > > > > -----Original Message----- > > From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk] > > Sent: Wednesday, August 02, 2000 11:43 > > To: gary child > > Cc: informix-list@iiug.org > > Subject: Re: Adding additional Listener ports > > > > > > gary child wrote: > > > > > > It has been suggested to me that adding additional Listener > > ports to /etc/services > > > and corresponding aliases to sqlhosts may provide a > > performance gain by spreading > > > user connectivity between the multiple listener ports. We > > run 7.31.UC5 on > > > HPUX11 and all connections via tcp. > > > We do not use shared memory connections because we are > > utilising HP Shmem_magic > > > to address additional shared memory. > > > > Hang on, are you saying you are using TCP for local connections? Why > > don't you use stream pipes? Adding multiple listeners is only really > > useful if you have multiple network cards. I don't think you are going > > to see much gain with local connections unless you have > > 1000's of users. > > > > > I don't recall ever seeing anyone suggest > > > multiple listener ports as a tuning option so I'd be interested to > > > hear your thoughts. > > > > It is certainly a concept covered in the Sys Adm training course. > > > > Cheers, > > -- > > Mark. > > > > +----------------------------------------------------------+-- > > ---------+ > > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk > > |//////// /| > > | http://www.informix.com http://www.informixhandbook.com > > |///// / //| > > | http://www.iiug.org > > +-----------------------------------+//// / ///| > > | |This email will self-destruct in > > |/// / ////| > > | |10 sec. If you received this email > > |// / /////| > > | |in error, sorry about the mess. |/ > > ////////| > > +----------------------+-----------------------------------+-- > > ---------+ > >