Re: 3 parameter/onstat questions

Thanks for that one Jacques. I will implement the minimum to start off with. ( 800kb per cpu ). I have tested on a demo instance that it does in fact seem to work on my version. Thanks again, Floyd ----- Original Message ----- Subject: Re: 3 parameter/onstat questions Date: Tue, April 8, 2008 13:50 From: jprenaut@yahoo.com On Apr 8, 11:41 am, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > > I just got off the chat-with-labs with John Miller. He left me with 3 questions I > am hoping to get more info about, having failed to get anything useful from the > version 10 docs. > > I'm on ids10.0.fc5. > > > > 1) He strongly recommended having the chunk mode set to expanded 'always'. He said > that if it's not that way, I am suffering in performance because there is a > translation that needs to go on with each IO between the old type of IO and the > new type. ( something like that ). > > --So is this correct for my version ? > > -- If it is, then onmode -BC 2 would do it, is there any danger to that, or > does it take a while , or is it instantaneous. ( yes I know I can check, but I > would have to make an instance to check it on ). > > > > 2) He mentioned vpcache, as that it can be monitored with onstat -g vpcache. He > said that the vpcache is very useful for multicpu setups (us ). When I run that > onstat command, it shows a bunch of zeros, indicating that I am not using it. How > do I start using it, if its even possible on my version ? > > You have to add the paramenter VP_MEMORY_CACHE_KB to your onconfig > file, so you'd add it then have to bounce the server. I'm not sure > it's in 10.00.fc5, but it does appear to be in 10.00.fc6. However, if > the onstat was there, then I think that's probably a good indication > that the feature is also there. > > Jacques > > > > > 3) Is there a way I can determine if my other caches ( dictionary, dists, sql ) > are needing to be made bigger ? A guidliine on that ? > > > > Thanks for any pointers in the right direction. The docs have not been very useful > here. > > > > Thanks, > > floyd > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

Floyd Wellershaus wrote: > Thanks for that one Jacques. I will implement the minimum to start off > with. ( 800kb per cpu ). > > I have tested on a demo instance that it does in fact seem to work on my > version. > > Thanks again, > Floyd > > > > > > ----- Original Message ----- > Subject: Re: 3 parameter/onstat questions > Date: Tue, April 8, 2008 13:50 > From: jprenaut@yahoo.com > On Apr 8, 11:41 am, "Floyd Wellershaus" <fl...@fwellers.com> wrote: >>> I just got off the chat-with-labs with John Miller. He left me with 3 > questions I >> am hoping to get more info about, having failed to get anything useful > from the >> version 10 docs. >>> I'm on ids10.0.fc5. >>> >>> 1) He strongly recommended having the chunk mode set to expanded > 'always'. He said >> that if it's not that way, I am suffering in performance because there is a >> translation that needs to go on with each IO between the old type of IO > and the >> new type. ( something like that ). >>> --So is this correct for my version ? >>> -- If it is, then onmode -BC 2 would do it, is there any danger to > that, or >> does it take a while , or is it instantaneous. ( yes I know I can check, > but I >> would have to make an instance to check it on ). >>> 2) He mentioned vpcache, as that it can be monitored with onstat -g > vpcache. He >> said that the vpcache is very useful for multicpu setups (us ). When I > run that >> onstat command, it shows a bunch of zeros, indicating that I am not > using it. How >> do I start using it, if its even possible on my version ? >> >> You have to add the paramenter VP_MEMORY_CACHE_KB to your onconfig >> file, so you'd add it then have to bounce the server. I'm not sure >> it's in 10.00.fc5, but it does appear to be in 10.00.fc6. However, if >> the onstat was there, then I think that's probably a good indication >> that the feature is also there. >> >> Jacques >> >>> 3) Is there a way I can determine if my other caches ( dictionary, > dists, sql ) >> are needing to be made bigger ? A guidliine on that ? >>> Thanks for any pointers in the right direction. The docs have not been > very useful >> here. >>> Thanks, >>> floyd >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> >> It should work with your version although it's off by default. xC6 got famous by changing this. Please check http://www-128.ibm.com/developerworks/blogs/page/gbowerman?entry=memory_leak_in_ids_10 You can change it dinamically with onmode {-wm|-wf} VP_MEMORY_CACHE_KB=xxx Check the docs and experiment in development. Regarding your last question... The answer is not short... Once again, I could try to tease Mark Jamison... He has a very nice presentation about several cache management... Not sure if it went public or not... Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...