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
barai(at)cs(dot)ucr(dot)edu
http://www.benjaminarai.com <http://www.benjaminarai.com/>