Re: [Bacula-users] Building directory tree is very slowly

2007-01-11 Thread Ondrej PLANKA
Bill Moran napsal(a): > In response to Ondrej PLANKA <[EMAIL PROTECTED]>: > > >> Alan Brown napsal(a): >> >>> On Tue, 9 Jan 2007, Ondrej PLANKA wrote: >>> >>> > It sounds silly, but add individual indexes for JobId, PathId and > FilnameId as well as the 3-way one. >

Re: [Bacula-users] Building directory tree is very slowly

2007-01-11 Thread Bill Moran
In response to Ondrej PLANKA <[EMAIL PROTECTED]>: > Alan Brown napsal(a): > > On Tue, 9 Jan 2007, Ondrej PLANKA wrote: > > > >>> It sounds silly, but add individual indexes for JobId, PathId and > >>> FilnameId as well as the 3-way one. > >>> > >> Ok, do you have some tip, how can I add individua

Re: [Bacula-users] Building directory tree is very slowly

2007-01-11 Thread Ondrej PLANKA
Alan Brown napsal(a): > On Tue, 9 Jan 2007, Ondrej PLANKA wrote: > >>> It sounds silly, but add individual indexes for JobId, PathId and >>> FilnameId as well as the 3-way one. >>> >> Ok, do you have some tip, how can I add individual indexes? Because I >> think, my indexes are OK or not? > > ALT

Re: [Bacula-users] Building directory tree is very slowly

2007-01-10 Thread Steve Thompson
On Wed, 10 Jan 2007, Thomas Glatthor wrote: > for a 2,500,000 file-job my machine needs ~ 15 minutes > the databasequery is finished after ~1 minute, > but the director needs 14 minutes to build the tree or whatever happens > in this time . > also is the dir only using one cpu for his work, in

Re: [Bacula-users] Building directory tree is very slowly

2007-01-10 Thread Thomas Glatthor
for a 2,500,000 file-job my machine needs ~ 15 minutes the databasequery is finished after ~1 minute, but the director needs 14 minutes to build the tree or whatever happens in this time . also is the dir only using one cpu for his work, instead of four. i don't think that the database is the

Re: [Bacula-users] Building directory tree is very slowly

2007-01-10 Thread Alan Brown
On Tue, 9 Jan 2007, Ondrej PLANKA wrote: >> It sounds silly, but add individual indexes for JobId, PathId and FilnameId >> as well as the 3-way one. >> > Ok, do you have some tip, how can I add individual indexes? Because I think, > my indexes are OK or not? ALTER TABLE File ADD INDEX [name] {

Re: [Bacula-users] Building directory tree is very slowly

2007-01-09 Thread Ondrej PLANKA
Alan Brown napsal(a): > On Tue, 9 Jan 2007, Ondrej PLANKA wrote: > >> I searched, but I think, my indexes are OK, or not? >> >> mysql> show index from File; >> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation >> | Cardinality | Sub_part | Packed | Null | Index_type | Comment

Re: [Bacula-users] Building directory tree is very slowly

2007-01-09 Thread Alan Brown
On Tue, 9 Jan 2007, Ondrej PLANKA wrote: > I searched, but I think, my indexes are OK, or not? > > mysql> show index from File; > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation > | Cardinality | Sub_part | Packed | Null | Index_type | Comment | > +---++---

Re: [Bacula-users] Building directory tree is very slowly

2007-01-09 Thread Alan Brown
On Tue, 9 Jan 2007, Dan Langille wrote: >> when I want restore files, the building directory tree is very slowly >> (several minutes) for job, wich have for example 1,372,029 JobFiles. >> >> Do you have some tip for quicklier restore(quicklier building directory >> tree). > > Searching the mailing

Re: [Bacula-users] Building directory tree is very slowly

2007-01-09 Thread Ondrej PLANKA
Dan Langille napsal(a): > On 9 Jan 2007 at 16:52, Ondrej PLANKA wrote: > > >> Hi list, >> >> when I want restore files, the building directory tree is very slowly >> (several minutes) for job, wich have for example 1,372,029 JobFiles. >> >> Do you have some tip for quicklier restore(quicklier b

Re: [Bacula-users] Building directory tree is very slowly

2007-01-09 Thread Dan Langille
On 9 Jan 2007 at 16:52, Ondrej PLANKA wrote: > Hi list, > > when I want restore files, the building directory tree is very slowly > (several minutes) for job, wich have for example 1,372,029 JobFiles. > > Do you have some tip for quicklier restore(quicklier building directory > tree). Searchi