… older kernel, so I was decided to test it in strict_sync mode. As I understand FusionIO in default mode, like… to internal memory, not to final media. And FusionIO has “strict_sync” mode to guarantee fsync is trustworthy. So let’s…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… Slave status 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0… Slave status 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0… Slave status 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0…
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
… couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The problem was that FusionIO did not provide durability or results were too bad in strict mode, so I lost interest FusionIO for couple month. But… 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
… expect that our next release will no longer require the strict_sync setting for durability (without any performance loss) I am surprised about the low throughput – with or without strict_sync – are you testing with a single thread ? (Even for… very slow) Can you describe your test setup? Currently with strict_sync on I recommend writing large blocks using at least…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
…’ ‘CFLAGS=-O2 -mmmx -msse -msse2 -msse3 -pipe -march=nocona -fno-strict-aliasing’ ‘CXXFLAGS=-O2 -mmmx -msse -msse2 -msse3 -pipe -march=nocona -fno-strict-aliasing -O2 -mmmx -msse -msse2 -msse3 -pipe -march=nocona -fno-strict-aliasing -felide-constructors -fno-rtti…
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
… actually quite easy – you just need to enable strict mode: mysql> set sql_mode=STRICT_ALL_TABLES; Query OK, 0 rows affected… adjusted for column ‘article_id’ at row 1 Note however strict mode should not be taken lightly – it is good for…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… worth to note MySQL 5.0 introduces STRICT option which will makes error control more strict, what is often expected by the… on this behavior, please at least add option such as –strict-start which would require server to start without serious errors…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based…-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open…
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…
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…
