Frank Sweetser wrote: > On Thu, Sep 07, 2006 at 10:58:49AM +0200, Masopust, Christian wrote: >> Hello Frank, >> >> thanks a lot for this info! but.... :-))) >> >> could anybody give the complete info (maybe also modify the wiki-page) how >> these indexes should be created? > > The best place to find that is in the documentation for your database. That > way you can make sure you're getting accurate information, as opposed to > something for a previous version or the like. >
Amazing, my dbcheck at home was searching for orphaned Filename records the whole day, and I finaly did mysaladmin kill on the query. Then I did: mysql bacula create index Job_FilesetId_idx on Job(FileSetId); create index Job_ClientId_idx on Job(ClientId); create index File_PathId_idx on File(PathId); create index File_FilenameId_idx on File(FilenameId); This took about 30-45 minutes Then I did dbcheck verbose off , modify on 16) ALL (3-15) 2-3 minutes , and all done. Now you don't have to care if it lock tables or not, just run it. (and the wiki is bookmarked ) /birger ------------------------------------------------------------------------- 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
