Re: [Bacula-users] Large Bacula databases and bacula's dbcheck

On Sat, Jan 28, 2006 at 09:48:11AM -0600, Jeffrey L. Taylor wrote: > I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and > Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I > killed the orphaned path check after 2 days. Out of curiosity, how many rows do you have i

Re: [Bacula-users] Large Bacula databases and bacula's dbcheck

On 28 Jan 2006 at 12:54, Drew Tomlinson wrote: > On 1/28/2006 7:48 AM Jeffrey L. Taylor wrote: > > >I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and > >Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I > >killed the orphaned path check after 2 days. > > > > >

Re: [Bacula-users] Please remove me from the list

On Fri, Jan 27, 2006 at 02:44:54PM +, [EMAIL PROTECTED] wrote: > > > A great many lists, including this one, add unsubscribe information to the headers of all traffic. So by examining the headers, you can learn how to unsubscribe. List-Unsubscribe:

Re: [Bacula-users] Large Bacula databases and bacula's dbcheck

On 1/28/2006 7:48 AM Jeffrey L. Taylor wrote: I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I killed the orphaned path check after 2 days. This made an amazing difference for me as well. I know basically

Re: [Bacula-users] Re: Viewing MySQL Output (Was: Large Bacula databases and bacula's dbcheck)

On 1/28/2006 9:59 AM Sebastian Stark wrote: Am 28.01.2006 um 17:58 schrieb Drew Tomlinson: I tried 'less' but it didn't work for me as it still wrapped. Is there something else? Type "-S" within less. Or do export LESS=-S (or setenv LESS -S for tcsh) in your shell startup file. Th

Re: [Bacula-users] Re: Viewing MySQL Output (Was: Large Bacula databases and bacula's dbcheck)

Am 28.01.2006 um 17:58 schrieb Drew Tomlinson: I tried 'less' but it didn't work for me as it still wrapped. Is there something else? Type "-S" within less. Or do export LESS=-S (or setenv LESS -S for tcsh) in your shell startup file. -

[Bacula-users] Re: Viewing MySQL Output (Was: Large Bacula databases and bacula's dbcheck)

On 1/28/2006 6:27 AM Deann Corum wrote: Thanks Jeffrey and Attiila. I'll look at the dbcheck script and see what I can figure out. And the mysqladmin processlist command is very helpful. It's also good to know others out there have large Bacula databases. I still wonder what the largest known

Re: [Bacula-users] Large Bacula databases and bacula's dbcheck

I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I killed the orphaned path check after 2 days. HTH, Jeffrey Quoting Deann Corum <[EMAIL PROTECTED]>: > Thanks Jeffrey and Attiila. I'll look at the dbcheck script

Re: [Bacula-users] Large Bacula databases and bacula's dbcheck

Thanks Jeffrey and Attiila. I'll look at the dbcheck script and see what I can figure out. And the mysqladmin processlist command is very helpful. It's also good to know others out there have large Bacula databases. I still wonder what the largest known one is! It seems we're ok even though w