Re: IFX_NETBUF_PVTPOOL_SIZE

On 4 Oct, 20:07, mohitanch...@gmail.com wrote: > Version IDS 10: > > I was reading Performance guide and came accross > IFX_NETBUF_PVTPOOL_SIZE, which seems to be very interesting. I have > some questions: > > 1. Is this pool used by Informix to store incoming or outgoing data > from application clients. > 2. So, what happens if client is trying to send large blob say 2 MB or > 10 MB, how does informix receives the data, is it always in 4k chunks. > Does it help if in sqlhosts for option 'b' higher size is specified. > 3. How to determine if IFX_NETBUF_PVTPOOL_SIZE should be set to and > how much to set to. I looked at onstat -g ntu but didn't get much out > of it. I know this question is probably based on the current situation > but I am looking for something that tells me how to determine the > correct size, or if at all I should consider increasing this size. > 4. Is it better to use private pool than using global pool ? 1. I would imagine both 2. Read the manual about what the 'b' option from sqlhosts does and what the IFX_NETBUF_SIZE environment variable does. 3. To see if it is set look at the environment of each client and the environment of when the server is started. To see what it should be set of look at the output of onstat -g ntu. Well if there are no free buffers in the private pool for the sessions and onstat -g ntm shows the free buffer threshold was exceeded andthis happens a lot (where a lot is a judgement call or can be determined by benchmarking the system) then increase the value and benchmark again.