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 supposed to

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 reasons i

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 the

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 file records

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 Bacula's database reasonably

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 periodically is pretty much a

[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

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 once,

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 obsolete

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 problems. One of the reasons i

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 gets

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 via cron and

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 in read-only mode

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