Finding out db cache useag

#1

Is There a way to find out, at run time, the cache usage of a certain
db?

I'm setting a certain cache size and I'd like to know when the
application is about to exeed this value.

Thanks ahead
Shahar

#2

I have 2 suggestions:

The first is to look at the db_stat utility.

The second is to look at the memp_stat() method. For more information:
http://www.sleepycat.com/docs/api_cxx/memp_stat.html

In particular look at the per database data structure DB_MPOOL_FSTAT.

Ron
S...cat Software.

#3

oh

I'm not using Env
Should I?

db_stat does not return memory usage as far as i can tell...

Thanks again
Shahar

#4

ok
I've set up an env and I can get the DB_MPOOL_FSTAT

just to make sure:

In order to find out cache usage:

st_page_create * st_pagesize = current cache usage by db

Is that correct?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Finding out db cache useag

comp.databases.berkeley-db comp.databases.berkeley-db

Finding out db cache useag - 11-17-2005 , 06:58 AM

Re: Finding out db cache useag - 11-17-2005 , 04:29 PM

Re: Finding out db cache useag - 11-20-2005 , 12:22 AM

Re: Finding out db cache useag - 11-20-2005 , 08:36 AM