Hi,
I am currently doing
large weekly updates with fsync=off. My updates involves SELECT, UPDATE,
DELETE and etc. Setting fsync=off works for me since I take a complete
backup before the weekly update and run a "sync" and "CHECKPOINT" after each
weekly update has completed to ensure the data is all written to disk.
Obviously, I have
done this to improve write performance for the update each week. My
question is if I install a 3ware or similar card to replace my current
software RAID 1 configuration, am I going to see a very large improvement?
If so, what would be a ball park figure?
Benjamin Arai
