> I'm having this setup here:
>
> linux 64 bit server with RAID 5 for database storage. My database is stored on raw device.
>
> Right now I'm using FW=ON for this setup.
>
> any ideas how to optimize performance for this configuration?
>
> The problem is with write operations. They take to much time and this is OLTP database so write should be very fast.
>
> I'm considering the option to migrate this RAID back to HDD in order to speed up write operations.
>
> I'm also considering the option of FW=OFF with MaxUnflushedWrites set to some low value like 100 and MaxUnflushedWriteTime set to 4-5 seconds.
>
> Any other ideas?

I'm no Linux expert, but there are two things which come to my mind:

- Paul Reeves presented at the conference that RAID 5 is a bad idea for
a database server
- AFAIK there are issues with ext4 and forced writes ON


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/