[p4] Running Obliterate command on perforce server live databases

[Brad Holt]

It used to be a big problem given that the database would be locked for
a very long time.  For us this meant that we could not ever do it on a
live database.  However, over the last couple of years, perforce have
drastically improved the obliterate speed.

There are few things that can speed it up as well.  If you have a large
set of obliterates to do, I would recommend first paring down your
metadata (get rid of old, obsolete clients, labels, users, etc and
restore from a checkpoint (this is also a great time to sneak in and
test how long an obliterate will take).  This can make the purges much
faster.  Also try to pass in the obliterates as one file mass instead of
maybe one file at a time in a -x response file or lots of smaller calls.

If you still find that it takes too long to do, you can do it offline on
a copy of the database, and then replay that journal over your live
database.  There have been quite a few threads on this with details.

-----Original Message-----
From: perforce-user-bounces at perforce.com
[mailto:perforce-user-bounces at perforce.com] On Behalf Of kumar Namburu
Sent: Wednesday, September 26, 2007 6:07 AM
To: perforce-user at perforce.com
Subject: [p4] Running Obliterate command on perforce server live
databases

In our environment, we have been receiving requests for obliterating
obsolete branches and temporary branches.
1)Are they are any dangerous consequences of running obliterate commands
on
live databases?
2) Our current database size is 20 GB and we project the growth to about
100GB in next one year. The database locking period time/interval is
quite
manageable at the current point of time.
Looking forward for expert comments on their experience with regard to
performance of obliterate command wilth a huge database sizes?. Any
ideas on
the parameters (like number of files/database size/integration history
and
so on ..) on which performance/time for locking  for obliterate command
rely
upon.
_______________________________________________
perforce-user mailing list  -  perforce-user at perforce.com
http://maillist.perforce.com/mailman/listinfo/perforce-user