> On Mon, 6 Nov 2006 09:25:33 +0100, Andras Horvai said:
>
> I reindexed my tabels, but it seems that it didn't help too much.
> Still takes "forever" to prune/purge my volumes. Forever means not
> hours but 30 minutes instead of few minutes which was in the past.
> What else could I do? This
I reindexed my tabels, but it seems that it didn't help too much.
Still takes "forever" to prune/purge my volumes. Forever means not
hours but 30 minutes instead of few minutes which was in the past.
What else could I do? This the mysql output of indexing:
mysql> CREATE INDEX PathIdIdx ON File(Pat
On Sun, Nov 05, 2006 at 01:03:40PM +0100, Andras Horvai wrote:
> Have you already tried this? My catalog is around 1 GB large.
> How long will it take to reindex it?
It's hard to say, but it could easily take hours, especially if you don't
have a particularly fast machine, so just be patient with
Thanks for your answer! I started to create the new indexes and let's
see what happen. I will use these commands:
CREATE INDEX PathIdIdx ON File(PathId);
CREATE INDEX FilenameIdIdx ON File(FilenameId);
CREATE INDEX FileSetIdIdx ON Job(FileSetId);
CREATE INDEX ClientIdIdx ON Job(ClientId);
Have yo
On Sat, Nov 04, 2006 at 06:00:52PM +0100, Andras Horvai wrote:
> Hi,
>
> I'm using bacula Version: 1.38.11 (28 June 2006) and mysql 4.0.24 with
> a debian sarge system. My problem is that I am not able to purne or
> purge my volumes. It seems that it takes forever to purne/purge the database
> rec
