Jeffrey L. Taylor wrote: > Quoting Dominic Marks <[EMAIL PROTECTED]>: >> I don't think this made it to the list yesterday: >> > [snip] >> Anyway, dbcheck did something bad to MySQL over night and it had to be >> restarted because Bacula and the MySQL Server both stopped responding. >> I'm going to dump and archive the catalogue in its broken state and >> then start with a fresh one unless anyone has any great ideas? I'm >> open to all suggestions - but obviously I need to get the backup >> system back online ASAP. >> > > On an unmodified Bacula system, dbcheck can run for days. And it > locks the database so no backups or restores can be done until it > finishes. Look in the archives for this list about adding indexes. > There are two or three indexes that can be added. These additions cut > the runtime for over two days on my SOHO system with 5 computers to a > few minutes.
Hmm. I've renamed the Bacula database on the MySQL server so I can try and fix what I have in there already. I can't wait for several days downtime on a critical service like this though. I'll try adding the indexes and hopefully that will increase performance. This installation is for about 70 desktops, laptops and servers. Database is about 1.5GB. Thanks very much all who responded. Dominic > HTH, > Jeffrey > > > ------------------------------------------------------------------------- > 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 ------------------------------------------------------------------------- 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
