On Wed, May 03, 2006 at 11:02:20AM +0100, Alan Brown wrote: > On Tue, 2 May 2006, Christoph Haas wrote: > >While I used settings from the "large" my.cnf example configuration file > >and had a slight speedup it still took longer than a few hours so I > >interrupted. > > What indexes do you have?
PRIMARY KEY (`FileId`), KEY `PathId` (`PathId`), KEY `FilenameId` (`FilenameId`,`PathId`), KEY `JobId` (`JobId`) > >Following to hints from the helpful inhabitants of #bacula on > >irc.freenode.net I ran a "dbcheck" searching for orphaned rows. Voila, my > >row count decreased from 21 million to 3 million. I even needed two runs > >because dbcheck seemed to have an upper limit of 10 million entries to > >delete. :) > > That won't help, but proper indexing should speed things up. Au contraire. In this case the indexing is slowing down the import. Importing the pure data is taking a few minutes only while creating the indexes is taking a day. Of course you are right that once the indexes are created the Bacula jobs will run much faster. Kindly Christoph ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
