DB Corruption and Tuning

My DB hit the same corruption again yesterday. I believe I found the
cause. I looked back through my commit logs and the same user was
always the last to commit prior to my crash. Upon interviewing here I
discovered that when she submitted via Tortoise 113, the files would
start to go up, there would be a connection lost error and upon resubmit
the submission would work. This submission was the last prior to svn
becoming wedged.

I soon discovered the following interesting aspects of her workspace

1. The commit - fail - recommit problem
2. A bunch of files that she thought she had committed didn't show up in
the build
3. If she did an update she got scores of conflicts even though she had
the latest version of the files (or so svn command line 1.1.3 claimed)

We created a new workspace and migrated individual files over and she
appears to be ok now. The 3 problems above are gone and I haven't
crashed in almost 12 hours even though she checked in.
-----------------

So, my problems may be been related to a corruption in a workspace. Or
the problems with the server may have caused the corruption. It could
even be a symbiotic relationship.

I am considering two courses of action:
1. Investigating the file system based FCFS for backend storage
2. Looking into tuning my BerkeleyDB backend

I developer at my shop noticed the following email on the developer list
        http://svn.haxx.se/dev/archive-2004-12/0369.shtml

It is possible that the default svn tuning options in DB_CONF are viable
for a small environment, but do not serve a 7 GB environment with 20-40
users.

I have the db_stat (with -m option) command running every 10 minutes
making samples so I have an idea of cache usage and a few other
statistics.

QUESTIONS -------------------------------------
Does anyone have any experience with tuning, especially with increasing
the cache? I haven't yet found the right syntax for setting it higher
than the 256KB.

Thanks...

--
Peter Kahn
pkahn@connected.com
Connected Corporation,
A subsidiary of Iron Mountain Incorporated
PackReq Described:
http://svn:8080/svn/repos/Welcome_To_SVN/buildFarmTutorial.html#Packager
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org