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(PathId);
Query OK, 6390188 rows affected (1 hour 2 min 53.22 sec)
Records: 6390188 Duplicates: 0 Warnings: 0
mysql> CREATE INDEX FilenameIdIdx ON File(FilenameId);
Query OK, 6390188 rows affected (1 hour 11 min 47.64 sec)
Records: 6390188 Duplicates: 0 Warnings: 0
mysql> CREATE INDEX FileSetIdIdx ON Job(FileSetId);
Query OK, 268 rows affected (0.30 sec)
Records: 268 Duplicates: 0 Warnings: 0
mysql> CREATE INDEX ClientIdIdx ON Job(ClientId);
Query OK, 268 rows affected (0.20 sec)
Records: 268 Duplicates: 0 Warnings: 0
The configuration: AMD Athlon(tm) 64 Processor 2800+; 512 MB ram; SATA
disks
Kernel: 2.6.8-2; Mysql 4.0.24
The database size is around 1 GB.
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Sunday Sunday, November 05, 2006 1:31:35 PM
Subject: [Bacula-users] cannot prune/purge volumes
>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 it.
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
