… older kernel, so I was decided to test it in strict_sync mode. As I understand FusionIO in default mode, like Intel… to internal memory, not to final media. And FusionIO has “strict_sync” mode to guarantee fsync is trustworthy. So let’s benchmark…
Comment: Testing FusionIO: strict_sync is too strict...
June 18, 2009 By 8 Comments
… require the strict_sync setting for durability (without any performance loss) I am surprised about the low throughput – with or without strict_sync – are… very slow) Can you describe your test setup? Currently with strict_sync on I recommend writing large blocks using at least two… serialized by a file lock anyway). For strict-sync you can think of the sync writes as participating in group commits that are…
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
… FusionIO: strict_sync is too strict…. The problem was that FusionIO did not provide durability or results were too bad in strict mode… provides durability even without strict_mode (see http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too-strict/#comment-676717). While…
Comment: Testing FusionIO: strict_sync is too strict...
June 18, 2009 By 8 Comments
… if we will be able to rely on fsync without strict_sync and with the same performance! I am testing tpcc-like… on device may be different. Please let me know when strict_sync is not be needed, I will re-test it. Currently…
Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 19, 2010 By 15 Comments
…/ http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too-strict/ I’m sorry if I overlooked it, but I…
Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 19, 2010 By 15 Comments
…/ http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too-strict/ I’m sorry if I overlooked it, but I…
Comment: Testing FusionIO: strict_sync is too strict...
November 13, 2009 By 8 Comments
… to enlist your help in re-testing our product without strict_sync and simulating power loss scenarios to ascertain that there is…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_pagesblogpercona.commanual innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona…_engineblogpercona.commanual symbolic_linksblogpercona.commanual sync_binlogblogpercona.commanual sync_frmblogpercona.commanual sync_master_infoblogpercona.commanual sync_relay_logblogpercona.commanual sync_relay_log_infoblogpercona.commanual sysdate…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… when you have strict durability and recover-ability requirements, that is innodb_flush_log_at_trx_commit=1, sync_binlog=1 and… binlog trx=0, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 59.45 468.59 33.11… thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371.17 381.03…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
… be more or less picky. In default, slave_exec_mode=STRICT mode replication will stop if row to be updated or… key error and row not found errors will be ignored. Strict Mode with row level replication will not detect all conflicts… master and slave and replication will get silently out of sync. So back of our topic of auto_increment_increment and…
