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 you already tried this? My catalog is around 1 GB large. How long will it take to reindex it? Andras -----Original Message----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Saturday Saturday, November 04, 2006 6:52:27 PM Subject: [Bacula-users] cannot prune/purge volumes >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 > records. Did anybody meet this problem? I enter the media id of the > volume and nothing happens. I don't receive my bconsole prompt back. Pruning can take an exorbitantly long time if you don't have good indexes created on your catalog. http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#why_does_dbcheck_take_forever_to_run has some sample indexes that you might try adding. Check the mysql manpage for your version of mysql to get the correct commands to add them. -- 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
