On Wed, 29 Jun 2005, Jeremie Le Hen wrote:
Could you try mounting the filesystem where the database lives with the noatime option, and re-run your tests ? IIRC from previous threads on this subject, Linux doesn't really honor this while FreeBSD does, which pulls down the performances.
I think you mean the async option. Neither would make much differerce. atimes are cached in ffs, so mounting with noatime only makes much difference if lots of different files are read, which is exactly what doesn't happen when data is in a database instead of in separate files. Mounting with async can make a large difference, but normally makes no difference with ffs, since ffs is normally configured with soft updates and the async option is silently ignored in this configuration. You could try mounting with the sync option for all OSes. This should make them all very slow, but the results might be interesting since it is the only sync-related mount option that gives similar behaviour at the fs level. It might also show if the problem is related to syncing. Bruce _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[EMAIL PROTECTED]"