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.
>>>>>
>>>>>
>>>> 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] {column} ;
>>>
>>> so...
>>>
>>> ALTER TABLE File ADD INDEX file_jobid_idx JobId ;
>>> ALTER TABLE File ADD INDEX file_pathid_idx PathId ;
>>> ALTER TABLE File ADD INDEX file_filenameid_idx FilenameId ;
>>>
>>>
>> I really done this individual indexes, but building directory tree for
>> Jobs are still very slowly.....
>>
>
> Index problems are probably the most common reason for this, but they're
> not the only possible cause.
>
> I didn't see any hardware details -- perhaps you posted it earlier and
> I missed them. Bacula will need a lot of RAM to store that large of a
> directory tree. Monitor top, iostat, and any other sys monitoring programs
> you can during the tree build.
>
>
Backup server has 3 GB RAM memory, Intel(R) Xeon(TM) CPU 2.40GHz with
512 KB cache size.
When Building directory tree for Jobs, output of top is:
mysqld eating about 41% CPU and 1,1% of memory
bacula-dir eating about 88% CPU and 0,8% of memory
> In our case, we decided to add another gig of RAM to backup server and things
> are nice and fast now.
>
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
