Re: Apache access slows down

>Does it remain slow if you stop httpd, making sure all the
>threads/processes are killed?
>
It remains slow until the repository is replaced with the backup

>The db_stat utility shows information about the Berkeley database.
>Perhaps you could compare numbers before and after a slowdown. Start
>with a "fast" repository, run a few svn:// checkouts and then run
>db_stat to get some "before" numbers. Compare these with values after
>an http:// checkout. Try things like
>
> db_stat -e -h path/to/repo/db
> db_stat -c -h path/to/repo/db
> db_stat -l -h path/to/repo/db
> db_stat -m -h path/to/repo/db
>

Tried the db_stat. The significant thing appears to be the huge number of
locks; here is the diff of the -c, similar for the others.

1c1
< 80 Last allocated locker ID.

---
>432   Last allocated locker ID.
7,14c7,14
< 0     Number of current locks.
< 17    Maximum number of locks at any one time.
< 0     Number of current lockers.
< 17    Maximum number of lockers at any one time.
< 0     Number of current lock objects.
< 17    Maximum number of lock objects at any one time.
< 6030  Total number of locks requested.
< 6030  Total number of locks released.
---
>14    Number of current locks.
>65    Maximum number of locks at any one time.
>17    Number of current lockers.
>66    Maximum number of lockers at any one time.
>14    Number of current lock objects.
>51    Maximum number of lock objects at any one time.
>3279992       Total number of locks requested.
>3279970       Total number of locks released.
23,24c23,24
< 0     The number of region locks granted after waiting.
< 9423  The number of region locks granted without waiting.
---
>39    The number of region locks granted after waiting.
>3492667       The number of region locks granted without waiting.
I left this test running until the locks were 5,000,000 or so and killed svn 
(keyboard interupt is never processed).
_________________________________________________________________
Hot chart ringtones and polyphonics. Go to  
http://ninemsn.com.au/mobilemania/default.asp
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org