… MySQL 5.0 mainly error control was improved, such as strict mode was added to change famous MySQL behavior of cutting too… catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result in errors. The other… it beating up people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled MyISAM is used…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute… 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… `uid` (uid, update_time), INDEX `bar` (some_other_columns) …. ) ENGINE=InnoDB; When he ran this query: SELECT MIN(update_time) FROM…_mode does not help you here. Although 0024-06-21 is technically outside the supported range for DATE/DATETIME, neither TRADITIONAL, STRICT_ALL_TABLES, or STRICT_TRANS_TABLES produces so much as a warning. Is…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, but I see that Galera strictly requires innodb_autoinc_lock_mode=2 and tries to manage innodb_autoinc_lock_mode / auto_increment_offset – For deadlocks…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…/” default-character-set=latin1 default-storage-engine=INNODB #default-storage-engine=MyISAM sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE…=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=20M innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=4M innodb_buffer_pool…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… of making other queries slower by increasing the global value. innodb_purge_batch_size is a performance enhancement, Should also be… we expect most tables to be InnoDB and use innodb_file_per_table. sql_mode also uses STRICT_TRANS_TABLES by default. You were… features because of caution or backwards compatibility. Say the new innodb checksums in hardware, that 5.5 doesn’t understand, or…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…, the problem appears when you have strict durability and recover-ability requirements, that is innodb_flush_log_at_trx_commit=1, sync… dies, automatically switching from write-back to write-through cache mode. We benchmarked the systems with sysbench multi-table and oltp… order to summarize: the fix improves performance substantially when both innodb_flush_log_at_trx_commit=1 and sync_binlog=1…
Comment: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_rollback_on_timeout There are cases where it rolls… wanted to escalate to errors without changing SQL_MODE (so we could enable strictness in dev and run our test suite; changing…
