dbTalk Databases Forums  

Slow startup problem

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


Discuss Slow startup problem in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Guru
 
Posts: n/a

Default Slow startup problem - 11-01-2006 , 11:46 PM






Hi,

I am using db-4.3.28 on AIX-5.1.


Flags used are------

DB Flags = DB_CREATE| DB_AUTO_COMMIT|DB_THREAD;

Environment Open Flags = DB_RECOVER |DB_CREATE | DB_INIT_LOCK |
DB_INIT_LOG
Quote:
DB_INIT_MPOOL | DB_INIT_TXN|DB_THREAD|
Environment set_flags = DB_TXN_WRITE_NOSYNC|DB_LOG_AUTOREMOVE

When i add around 10000 items of size 256bytes to my application and
restart my application. it takes more time in ENV and DB open.

P.S. I am using only one DB handle for a given environment.

Please help me out in solving this problem.

Thnks and Regsrds,
Gurpreet



Reply With Quote
  #2  
Old   
Philip Guenther
 
Posts: n/a

Default Re: Slow startup problem - 11-03-2006 , 11:41 PM






On Nov 1, 9:46 pm, "Guru" <gurpreeth... (AT) gmail (DOT) com> wrote:
....
Quote:
Environment Open Flags = DB_RECOVER |DB_CREATE |
DB_INIT_LOCK | DB_INIT_LOG | DB_INIT_MPOOL |
DB_INIT_TXN|DB_THREAD
....
When i add around 10000 items of size 256bytes to my
application and restart my application. it takes more time
in ENV and DB open.
Database recovery has to examine all the transaction log from at least
as far back as the point of the last checkpoint. So, how often are you
calling DB_ENV->txn_checkpoint()?


Philip Guenther



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.