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.
>
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
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
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
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
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] {
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
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 |
> +---++---
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
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
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
11 matches
Mail list logo