On Mon, 1 May 2006, John Kodis wrote:
You have more CPU than I do, but only about half the memory. Since you say that the disks are thrashing, I'd guess that the lack of memory is more likely to be the culprit than the difference in databases. There have, however, been some messages posted here indicating that MySQL needs more attention to tuning when backing up this many files than a similar Postgres installation does.
By way of comparison my systems were thrashing badly even with 2Gb of ram because mySQL wasn't using enough memory. Allowing it to grow to 1Gb ram solved it almost entirely.
Adjusting /etc/my.cnf is pretty much a necessity on large database systems, or mysql will make extensive use of temporary files and things can grind to a halt quickly. The default settings are only ok for small systems or for testing.
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
