Tuesday, March 1, 2011

How to improve the mysql write performance

when we use the mysql replication, If the sync_binlog
is not set to 1, there is a risk of corruption of the binary log if the
server crashes. But, in many filesystems/OS, sync_binlog=1 is currently way
too slow (sometimes 2-4 times slower than set to 0). we can solve these by following solutions:
1)wait the mysql version upgrade to 5.6,we can get the information from http://forge.mysql.com/worklog/task.php?id=4925

2)change the linux file system to solaris ZFS or use Linux XFS. we can get the information from peter's URL:

3)we want to change the OS or file system,we can change the linux file system flush cache time as following:
 mount -o remount,notatime,nodiratime,data=ordered,barrier=0,commit=1 /
4)Using a write cache protected by battery (BBWC),we can get info from URL:

No comments:

Post a Comment