Re: [Bacula-users] How long should volume pruning take?

2006-09-25 Thread Uwe Schuerkamp
On Sat, Sep 23, 2006 at 09:30:20PM +0200, Kern Sibbald wrote: I'm not convinced the indexes are the same. Some people say yes, some say no, and it seems to be also dependent on whether one is talking about MySQL as you are or PostgreSQL. The best solution is to test for your particular

Re: [Bacula-users] How long should volume pruning take?

2006-09-25 Thread Kern Sibbald
On Monday 25 September 2006 10:00, Uwe Schuerkamp wrote: On Sat, Sep 23, 2006 at 09:30:20PM +0200, Kern Sibbald wrote: I'm not convinced the indexes are the same. Some people say yes, some say no, and it seems to be also dependent on whether one is talking about MySQL as you are or

Re: [Bacula-users] How long should volume pruning take?

2006-09-23 Thread Kern Sibbald
On Thursday 21 September 2006 08:41, Uwe Schuerkamp wrote: On Wed, Sep 20, 2006 at 03:10:27PM +0200, Kern Sibbald wrote: 10 GB is pretty big, but there are users with databases that large. Take a look at src/cats/make_mysql_tables. There are a few tips in that file for creating

Re: [Bacula-users] How long should volume pruning take?

2006-09-21 Thread Uwe Schuerkamp
On Wed, Sep 20, 2006 at 03:10:27PM +0200, Kern Sibbald wrote: 10 GB is pretty big, but there are users with databases that large. Take a look at src/cats/make_mysql_tables. There are a few tips in that file for creating extra indexes if you have slow pruning. Once you have the indexes

[Bacula-users] How long should volume pruning take?

2006-09-20 Thread Uwe Schuerkamp
hi folks, I am having an issue with automatic volume recycling, esp. with the time it takes to prune the oldest volume to allow it to be recycled. Our setup: - bacula 1.38.9 und Debian Linux (compiled from Source) - MySQL 5.0.20 - Database size: 10G (Total clients: 27, Total bytes stored:

Re: [Bacula-users] How long should volume pruning take?

2006-09-20 Thread Uwe Schuerkamp
On Wed, Sep 20, 2006 at 11:15:39AM +0200, Kern Sibbald wrote: For your performance problems: Please read the Catalog Maintenance chapter of the manual: http://www.bacula.org/dev-manual/Catalog_Maintenance.html In particular the Performance section in that chapter. It tells you how to

Re: [Bacula-users] How long should volume pruning take?

2006-09-20 Thread Kern Sibbald
On Wednesday 20 September 2006 11:34, Uwe Schuerkamp wrote: On Wed, Sep 20, 2006 at 11:15:39AM +0200, Kern Sibbald wrote: For your performance problems: Please read the Catalog Maintenance chapter of the manual: http://www.bacula.org/dev-manual/Catalog_Maintenance.html In