Caveat: Apparently I am not as well. :)

1.) I looked at the 65M issue. On my development box (OSX) I set it to -Xms128m -Xmx128m (basically arbitrary). So when I went to the remote hosting company, I purchase a similar amount. a. However, we are doing *very* little work (lots of product fetches and only a few product inserts and updates) and it runs out of memory *very* fast which I *assume* means it is my code, but I don't know. b. I am doing research and here is a "web recommendation" (for all that is worth)
                Whenever possible, Unidata recommends
-Xmx1500m for 32-bit systems, and -Xmx2048m --Xmx4096m for 64-bit systems. c. Since the host is 64-bit, I am wondering whether my assumptions may be off for 64-bit systems.

2. DataContext: Sorry, but I am getting confused on this one. I am using BaseContext.getThreadObjectContext() based on recommendations (I converted all the old DataContext refs to BaseContext, but I don't really understand it from reading the docs) and am *not* releasing it at the end of session. Not quite sure of how to do this properly.

3. Don't know how to set the cache to retain N number of objects. I experimented with
        query.setPageSize(RowsPerPage);
        query.setCacheStrategy(QueryCacheStrategy.SHARED_CACHE);
        query.setCacheGroups("product", "ProductList");

This seemed to help quite a bit but I still eventually ran out of memory. I recently removed *all* the SHARED_CACHE and it ran out of memory very fast.

Thanks for your input
Joe



On Sep 16, 2009, at 2:25 PM, Mike Kienenberger wrote:

Caveat: I'm not really an expert on Cayenne memory management.

1) Are you allocating enough heap memory to the app server to start
with?   I don't know what the default is these days, but in the old
days, an application by default only gets 64Mb of memory -- that's
pretty small.

2) Are you using a new DataContext per request? Or at least per session?

3) I seem to remember that the cache strategy is configurable.  Have
you configured a cache that only retains N number of objects for a
suitable value of N?

On Wed, Sep 16, 2009 at 2:11 PM, Joe Baldwin <[email protected]> wrote:
Hi,

I have asked this question a number of ways but I still have a very serious problem with Cayenne-specific memory management configuration associated
with Tomcat.

The problem with debugging is that given that I have very little visibility into the Cayenne memory management it is extremely difficult to debug this using conventional strategies. Also I am not requesting anything from the
system that is terribly exceptional so I am attempting to use default
settings as much as possible.

My strategy is to ask the experts for a Cayenne configuration and standard memory management steps I should take to conform to the new Cayenne memory
management design intentions.

Problem:
1. I have essentially a webstore, three tier design with Tomcat, Cayenne and
MySQL.
2. When after only a few queries of products, tomcat freezes up and reports
out of memory errors.

I have attempted to configure the caching strategy ask best as I can
understand from the docks but this only gets me a few more hours of usage before the out of memory errors. (I tried the SHARED_CACHE). The NO_CACHE
strategy is worse.

I would appreciate a set of steps (aka a primer) that should handle a
website with a lot of fetches of hundreds of data objects (i.e. products)
and very few updates.

Note: My gut feeling is that I am not properly managing the data object
array properly and it is leaking memory.

I would appreciate any input, but I would first like to know what the
minimum require steps are for managing at data object result set ArrayList so as to properly cache and then properly free the memory after it is no
longer needed.

Context: Tomcat, MySQL, Cayenne 3.0M6

Thanks,
Joe Baldwin



Reply via email to