…: in the default SQL mode, a duplicate index will throw a warning instead of a note. In strict mode, it will throw an…
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
…: 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: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
… not null” for not overly large positive integers. Consider using strict mode Storing different data when your application requests without throwing the… to be very loose by default. Consider running with sql_mode=strict_all_tables which will report error when data is truncated…
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.
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…
