On Thu, 15 Jan 2009 13:31:54 +0100, Bruno Friedmann <br...@ioda-net.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
