On Monday 03 July 2006 15:21, Alan Brown wrote: > On Mon, 3 Jul 2006, Kern Sibbald wrote: > >> Perhaps your hardware is slightly flaky? > > > > That is possible, but after having problems on 3 different machines that > > I upgraded from FC4 to FC5, I suspect that the problem is in their > > upgrade procedures that leaves the system in an unstable state. > > What about a clean install?
A clean install seemed to run fine, but I loaded it only on the test machine, then later loaded SuSE over it. > > > On my old 400MHz, i586, 256Meg ram machine, it crashed at least once a > > day after upgrading from FC4 to FC5. On SuSE 10.1 it has now been > > running 6 days with *absolutely* no problems. > > As with your FC problems, I suspect my suse ones are due to continual > upgrading since 8.2 - a clean installation on a Mac Powerbook is running > more than happily. Quite possibly this was the problem with the FC4 to FC5 update, and I suspected that I might need to do an "install", but after the slip ups they made in FC4 updates, I vowed that if I had to do a "clean" install, it would be to another distro ... > > >> I've just migrated my existing 1.36 bacula database from Mysql-MyIsam to > >> Mysql-InnoDB and am about to update to 1.38. > >> > >> > >> The first thing I noticed is that InnoDB is significantly larger and the > >> second thing was that database queries ran about 4 times faster... > > > > If I read this right you are saying that MyISAM runs 4 times faster than > > InnoDB ??? I only have used MyISAM since it has been the default. > > No, I'm saying that queries using InnoDB (especially things like dumps) > run 4 times faster. Well, that would be *really* good news for users who are having problems with millions of files per Job. > > >> Before redeploying the system in anger, does anyone have any hard data > >> about InnoDB performance vs Postgres for large-ish backup sets? > > > > There are those who will argue, but as currently programmed in Bacula, > > all the correctly done performance tests between MySQL-MyISAM and > > PostgreSQL are always 2 to 4 times faster on MySQL. > > Thanks. > > AB 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