RE: [viewvc-users] svndbadmin rebuild

"Millsap, James" <[email protected]> Wed, 15 Feb 2012 20:04:41 +0000
Newsgroups gmane.comp.version-control.cvs.viewcvs.user
Message-ID <EFA30B2F0470CE4EAD2014F9C1336B580A13B56C@bushexmb01.gsb.uchicago.edu>
Ok , it does go through and create the mysql tables.  Then it runs for a while, fills up the filesystem where viewvc is installed "/usr/local"  not the area that houses the mysql db "/mysqldb".  While it is running I can see it diffing things out, all I could presume is that it builds a text dump somewhere before it imports to mysql.  I will just throw a few more gigs at usr/local, and hope for the best. 

-----Original Message-----
From: C. Michael Pilato [mailto:[email protected]] 
Sent: Wednesday, February 15, 2012 1:09 PM
To: Millsap, James
Cc: ViewVC Users
Subject: Re: svndbadmin rebuild

[Note:  Your mail was sent to issue@, which is not the correct destination.
 In the future, please use our users@ list.]

On 02/15/2012 09:55 AM, Millsap, James wrote:
> Is there any way to estimate how much scratch space this will need?  I 
> am building the check-in db for the first time with a large svn repo.  
> It filled up the location where viewvc is installed.  If that is not 
> possible is there a way to redirect where it builds its dump file?  I 
> would just like to avoid wasting a bunch of space in /usr/local after this is complete.

'svndbadmin' populates a MySQL database ... there shouldn't be any "dump file" to speak of.

The data stored includes a row for every unique directory in the repository's history, a row for every unique base file name in the repository's history, a row for each unique author names, plus rows for each revision of every changed file that ties much of these other bits of data together via their primary keys.

No file contents are copied into the database, but most of the metadata in the repository is, as you can see, mirrored in the database.  Unfortunately, I have *no idea* how one might estimate the total storage cost of that metadata.

--
C. Michael Pilato <[email protected]>
CollabNet   <>   www.collab.net   <>   Distributed Development On Demand

------------------------------------------------------
http://viewvc.tigris.org/ds/viewMessage.do?dsForumId=4255&dsMessageId=2923028

To unsubscribe from this discussion, e-mail: [[email protected]].