observed significant performance improvement using "delaylog" in a real-world application

[Peter Niemayer]

On 08/11/2010 02:08 AM, Dave Chinner wrote:
> One thing that you might want to try to
> further improve performance is the logbsize=262144 option as well.
> That will help flush log IO faster by doing less IOs.

Tried that - but this did not have a positive effect.
(In fact a slightly negative one, but that could be within
the measurement accuracy).

> Also, if your workload is doing lots of fsync calls, then the
> optimisations I posted a few days ago should also help improve
> delaylog throughput.

We don't to any fsync's.

Regards,

Peter Niemayer