Re: My Informix Never free up memory!

steven wrote: > Jonathan Leffler <jleffler@earthlink.net> wrote: >>Your buffers are vastly underconfigured - 50000 would be a starting >>point, and go up from there. > > I skimed through the Informix Performance Guide, it said, that the > BUFFERS should be about 20% - 25% of physical memory size. For my > host equipment with 128M physical memory and page size if 2k, so I > think 50000 is too large to me. Should I set it to about 15000? I was misled by the 750 MB - yes, 32 MB, 15000 buffer pages - about right. Only 30 times as big as you started with, not 100 times. Apologies for exaggerating. >>However, your ESQL/C program is going to more relevant to debugging >>the memory leak. There's nothing in the ONCONFIG file that says "leak >>memory" or "do not free memory". Gut feel, you should be looking at >>the free statements in your program. > > > I still dont find any leak in my code :-(, is there any quite easy > tool? We need to know what you're doing. There are ways of using up lots of memory in the server - not because your code leaks on the client side but because it doesn't permit the server to release anything. And, since you're chewing up server-side memory, it would appear that you've found at least one of those. How many PREPARE statements do you have? How many DECLARE statements? How many FREE statements do you have? Without seeing some of your code - preferably a minimal test case that demonstrates the memory growth/leakage in the server - we aren't easily going to be able to help you. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/