mysql分组提交和实时fsync

核心提示： So how you can solve the problem ?那么，如何解决这个问题呢？Disable binary log. This could be option for slaves for example which do not need point in time re

So how you can solve the problem ?

那么，如何解决这个问题呢？

Disable binary log. This could be option for slaves for example which do not need point in time recovery etc. 禁用二进制日志。这在那些不需要及时恢复的slave上这个是可选的，以及其他类似的情况下。 Check if you OS is doing real fsync. You should to know anyway if you care about your data safety. This can be done for example by using SysBench: sysbench –test=fileio –file-fsync-freq=1 –file-num=1 –file-total-size=16384 –file-test-mode=rndwr. This will write and fsync the same page and you should see how many requests/sec it is doing. You also might want to check diskTest from this page http://www.faemalia.net/mysqlUtils/ which does some extra tests for fsync() correctness.

检查你的操作系统是否支持实时 fsync()。如果你关心数据的安全性，则无论如何都必须要知道。这可以用 SysBench 来检查： sysbench –test=fileio –file-fsync-freq=1 –file-num=1 –file-total-size=16384 –file-test-mode=rndwr. 。它会在同一个内存页写入和同步，你只要看一下每秒完成了多少次请求。也可以用 diskTest 来针对 fsync() 做这些检查。 Install RAID with battery backed up cache. This gives about the same effect as fake fsync() but you can make it secure (However make sure your drives are not caching data by themselves). The good thing RAID with battery backed up cache are becoming really inexpensive. 安装支持高速电池缓存的RAID。这么做类似实现了伪 fsync()，不过更安全(它确保无需由磁盘驱动器自己来完成数据缓冲)。现在这个系统花费也不太贵。

You also probably want to know if this bug is going to be fixed ? I’m not authority in this question but as Heikki describes it as fundamental task I’m not sure it will be done in 5.0 Good if it is done in 5.1.

你也许想知道这个bug是否已经被修复了？对这个问题我无权回答，不过如 Heikki 所述，它是 MySQL 5.0 中的一项基础工作，不知道在 5.1 中是否能够完成。