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? > 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. >> 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. >> 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
