Re: Disable logging

[Tobias Downer <toby@xxxxxxxxx>]

Justin,

Are you using a profiler to inspect the heap?  How much memory is being 
consumed, and what exactly is the object that is consuming the memory? 
It doesn't seem likely that the com.mckoi.store.LoggingBufferManager 
object itself would be using much memory but there are inner classes of 
that object (such as BMPage) that use memory to cache data.  If that 
class is consuming a lot of memory, then I would be interested in 
getting more details on your heap and your database configuration.

If you are seeing a lot of BMPage objects created, then I would suggest 
modifying the 'buffered_io_page_size' and 'buffered_io_max_pages' 
properties in your configuration.  The default these are set to are 8192 
and 256 respectively, which allows the cache to grow to about 2 MB in 
size (8192 * 256 = 2 MB).

Toby.


Justin Cobb wrote:
> Is there anyway to disable the logging for insertions into the database.
> I have a very large data set being inserted and
> com.mckoi.store.LoggingBufferManager memory use keeps growing throughout
> the insertions. I am just wondering that if I do disable logging will it
> fix this problem I m seeing? Thanks.