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:
http://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/

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:
 http://yoshinorimatsunobu.blogspot.com/2009/05/make-sure-write-cache-is-enabled-on.html

No comments:

Post a Comment