When using Berkeley DB, the default values of database config. might
lead to database corruption in a high-load situation, especially the
cache size. You may try to put the following in the DB_CONFIG :-
set_cachesize 0 536870912 1
set_lg_regionmax 262144
set_lg_bsize 2097152
Note : Cache size 512MB
For details, please reference the sleepycat documentation :-
http://www.sleepycat.com/docs/api_c/env_set_cachesize.html
Regards, John Mok
Andreas Pettersson wrote:
Bret Miller wrote:
I used to have problems with bayes locking and journaling. When it
finally corrupted the database, I decided it was time to put
it into a
real SQL database instead of using DB_File. Haven't had a
single problem
with bayes CPU or locking since.
Maybe it's time you consider using MySQL?
Bret
