…: strict_sync is too strict…. The problem was that FusionIO did not provide durability or results were too bad in strict mode, so… provides durability even without strict_mode (see http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too-strict/#comment-676717). While…
Post: Testing FusionIO: strict_sync is too strict...
June 15, 2009 By 8 Comments
… I was decided to test it in strict_sync mode. As I understand FusionIO in default mode, like Intel SSD, is “lying” to… internal memory, not to final media. And FusionIO has “strict_sync” mode to guarantee fsync is trustworthy. So let’s benchmark it… really loose transactions in case of power outage in default mode, this is something to check.
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
… is actually quite easy – you just need to enable strict mode: mysql> set sql_mode=STRICT_ALL_TABLES; Query OK, 0 rows affected (0… adjusted for column ‘article_id’ at row 1 Note however strict mode should not be taken lightly – it is good for reliability… to be fixed before they start working properly with this mode.
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
… are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM or other solutions… to be more or less picky. In default, slave_exec_mode=STRICT mode replication will stop if row to be updated or deleted… you set slave_exec_mode=IDEMPOTENT both duplicate key error and row not found errors will be ignored. Strict Mode with row level…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… innodb_stats_sample_pagesblogpercona.commanual innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona…
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 innodb…-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open…
Comment: Picking datatype for STATUS fields
August 15, 2008 By 24 Comments
Thanks Roland, Indeed this applies to standard behavior. If you get to Strict mode it is going to be changed… but a lot of other stuff is going to change as well. In most cases I’ve seen enabling strict mode also needed a lot of minor fixes to the application to make it work 
Comment: MySQL automatic data truncation can backfire
January 10, 2007 By 10 Comments
… the problem and this is why MySQL 5.0 gets strict mode. If you however look at general pictures in many cases… MySQL in the recent years – this is where we get Strict mode and similar changes from.
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…_pool_size 2097152 innodb_autoextend_increment 8 innodb_autoinc_lock_mode 1 innodb_buffer_pool_size 55050240000 innodb_change_buffering inserts…_stats_on_metadata ON innodb_stats_sample_pages 8 innodb_strict_mode OFF innodb_support_xa ON innodb_sync_spin_loops 30…
Comment: PROCEDURE ANALYSE
March 25, 2009 By 9 Comments
@Robert I think it’s a good opportunity to remind that sql_mode had best been set to ‘TRADITIONAL’ or otherwise strict mode, so that when attempting to INSERT texts *longer* than column width – an error is thrown (instead of silent truncation)
