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
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).
Ondra
--
12 matches
Mail list logo
