On Thu, 15 Jan 2009 13:31:54 +0100, Bruno Friedmann <bruno AT ioda-net DOT ch>  
wrote:

> Holikar, Sachin (ext) wrote:
>>
>>
>> Hi All,
>>
>>  Please find below the extract from the Bacula website....(
>> http://www.bacula.org/en/rel-manual/Catalog_Maintenance.html#SECTION0024
>> 80000000000000000
>> <http://www.bacula.org/en/rel-manual/Catalog_Maintenance.html#SECTION002
>> 480000000000000000>   )
>>
>> They say,
>>
>> Performance Issues Indexes :

I added the following indexes:

CREATE INDEX File_JobId_idx ON File(JobId);
CREATE INDEX File_PathId_idx ON File(PathId);
CREATE INDEX File_FilenameId_idx ON File(FilenameId);
CREATE INDEX Path_PathId_idx ON Path(PathId);
CREATE INDEX Job_FileSetId_idx ON Job(FileSetId);
CREATE INDEX Job_ClientId_idx ON Job(ClientId);
CREATE INDEX File_FilenameId-PathId_idx ON File(FilenameId,PathId);

This reduced dbcheck time from >24 hours to a few *seconds*. Adding the  
indexes themselves only took up to 15 seconds, but for now the database is  
relatively small at 200 MB for the whole /var/lib/mysql/bacula dir and  
it's a decent machine (quad core Xeon 2.33 GHz machine with 4 GB of RAM).

It remains to be seen whether the added indexing will impact insert/update  
performance, but I'll take a small performance hit if it means faster  
restores and sanity checks. The bottleneck here is NAS disk throughput so  
the number of concurrent jobs is limited.


------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users