Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Bill Moran
In response to Martin Simmons <[EMAIL PROTECTED]>: > > On Mon, 19 Feb 2007 15:10:26 -0500, Bill Moran said: > > > > In response to Martin Simmons <[EMAIL PROTECTED]>: > > > > > > On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: > > > > > > > > On the flip side, running dbcheck perio

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Martin Simmons
> On Mon, 19 Feb 2007 15:10:26 -0500, Bill Moran said: > > In response to Martin Simmons <[EMAIL PROTECTED]>: > > > > On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: > > > > > > On the flip side, running dbcheck periodically is pretty much a > > > requirement > > > for keeping Bacu

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Kern Sibbald
On Tuesday 20 February 2007 09:05, Erik P. Olsen wrote: > Frank Sweetser wrote: > > On Tue, Feb 20, 2007 at 01:04:44AM +0100, Erik P. Olsen wrote: > >> I wasn't aware that it was important to run dbcheck at certain > >> intervals. So I sat it up about 8 hours ago. It showed 4919334 orphaned > >> fi

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Eric Bollengier
> I wasn't aware that it was important to run dbcheck at certain intervals. So > I sat it up about 8 hours ago. It showed 4919334 orphaned file records and > it is now deleting them. How long time is it supposed to take? It has now > been deleting for almost 8 hours and mysqld takes about 85% of

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Kern Sibbald
On Monday 19 February 2007 15:06, Frank Altpeter wrote: > On 2/19/07, Bill Moran <[EMAIL PROTECTED]> wrote: > > In response to "Frank Altpeter" <[EMAIL PROTECTED]>: > > > My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has > > > currently some massive performance problems. One of the re

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Erik P. Olsen
Frank Sweetser wrote: > On Tue, Feb 20, 2007 at 01:04:44AM +0100, Erik P. Olsen wrote: >> I wasn't aware that it was important to run dbcheck at certain intervals. So >> I sat it up about 8 hours ago. It showed 4919334 orphaned file records and it >> is now deleting them. How long time is it suppos

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Frank Sweetser
On Tue, Feb 20, 2007 at 01:04:44AM +0100, Erik P. Olsen wrote: > I wasn't aware that it was important to run dbcheck at certain intervals. So > I sat it up about 8 hours ago. It showed 4919334 orphaned file records and it > is now deleting them. How long time is it supposed to take? It has now been

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Erik P. Olsen
Bill Moran wrote: > In response to Martin Simmons <[EMAIL PROTECTED]>: > >>> On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: >>> On the flip side, running dbcheck periodically is pretty much a requirement >>> for keeping Bacula's database reasonably sized. I have it run once a month >>>

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Bill Moran
In response to Martin Simmons <[EMAIL PROTECTED]>: > > On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: > > > > On the flip side, running dbcheck periodically is pretty much a requirement > > for keeping Bacula's database reasonably sized. I have it run once a month > > in read-only mode

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Martin Simmons
> On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: > > On the flip side, running dbcheck periodically is pretty much a requirement > for keeping Bacula's database reasonably sized. I have it run once a month > in read-only mode via cron and email us the results. When the extra stuff > ge

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Martin Simmons
> On Mon, 19 Feb 2007 15:06:13 +0100, Frank Altpeter said: > > On 2/19/07, Bill Moran <[EMAIL PROTECTED]> wrote: > > In response to "Frank Altpeter" <[EMAIL PROTECTED]>: > > > > > > My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has > > > currently some massive performance problem

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Frank Altpeter
On 2/19/07, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to "Frank Altpeter" <[EMAIL PROTECTED]>: > > > > My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has > > currently some massive performance problems. One of the reasons i > > think is caused by the massive amount of old and

Re: [Bacula-users] Cleaning up database records

2007-02-19 Thread Bill Moran
In response to "Frank Altpeter" <[EMAIL PROTECTED]>: > > My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has > currently some massive performance problems. One of the reasons i > think is caused by the massive amount of old and obsolete records. > For example, i had a client to backup

[Bacula-users] Cleaning up database records

2007-02-19 Thread Frank Altpeter
Hi there, My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has currently some massive performance problems. One of the reasons i think is caused by the massive amount of old and obsolete records. For example, i had a client to backup once, which has dissappeared some time ago. When this