On Tue, 22 Mar 2005, Jeff McCune wrote:
Index creation took 20 minutes, and dbcheck -f ran for 27 hours before I
killed it and wiped the entire machine to upgrade to RHEL4.
Soething's wrong with your setup then.
Currently, a Full backup of my /home volume is 480GB in just over 4 million
files. T
Kern Sibbald wrote:
On Tuesday 22 March 2005 22:00, Jeff McCune wrote:
>
Basically, the dbcheck program was operating as it should. However, the
operation I asked it to perform ran for over *three days* without sign
of completing anytime soon. After performing the proposed optimization,
the opera
On Tuesday 22 March 2005 22:00, Jeff McCune wrote:
> Roland Arendes wrote:
> > Hi
> >
> > This will speed up your dbcheck (and tree building before a restore)
> > drastically:
> >
> > Mysql
> >
> >>use bacula;
> >>ALTER TABLE File ADD INDEX (JobId, PathId, FilenameId);
> >
> > Wait for the index cr
Roland Arendes wrote:
Hi
This will speed up your dbcheck (and tree building before a restore)
drastically:
Mysql
use bacula;
ALTER TABLE File ADD INDEX (JobId, PathId, FilenameId);
Wait for the index creation to finish (takes some time on a huge db).
Index creation took 20 minutes, and dbcheck
Hi
This will speed up your dbcheck (and tree building before a restore)
drastically:
Mysql
> use bacula;
> ALTER TABLE File ADD INDEX (JobId, PathId, FilenameId);
Wait for the index creation to finish (takes some time on a huge db).
Bye
Roland
-Ursprüngliche Nachricht-
Von: Jeff McC
