[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Shrinking db4 log file size

From: Blair Zajac <blair_at_orcaware.com>
Date: 2002-07-26 06:10:05 CEST

Should we reduce the default log file size from 10 Mbytes to something
like 1 Mbyte? This will reduce the disk storage requirements for sites
running hot-backup.py pretty significantly I would think. Right now
each running of hot-backup.py will backup at least one 10 Mbyte file.
Reading

    http://www.sleepycat.com/docs/ref/log/limits.html

shows that its unlikely that we'll run out of log files.

Also, do people have any comments on increasing the in-memory log buffer
from 32 Kbytes to 128 Kbytes?

Here's what I've placed in my DB_CONFIG:

### Log file subsystem
#
# Read the documentation at
#
# http://www.sleepycat.com/docs/api_c/env_set_lg_bsize.html
# http://www.sleepycat.com/docs/api_c/env_set_lg_max.html
# http://www.sleepycat.com/docs/ref/log/limits.html
#
# Increase the size of the in-memory log buffer from the default of 32
# Kbytes to 128 Kbytes. Decrease the log file size from 10 Mbytes to
# 1 Mbyte. This will help reduce the amount of disk space required
# for hot backups. The size of the log file must be at least four
# times the size of the the in-memory log buffer.
set_lg_bsize 131072
set_lg_max 1048576

Best,
Blair

-- 
Blair Zajac <blair@orcaware.com>
Web and OS performance plots - http://www.orcaware.com/orca/
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Fri Jul 26 06:10:35 2002

This is an archived mail posted to the Subversion Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.