MySQL 5.6 ships with a default config file that sets the SQL mode to NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES . Here is what happens if you try to insert NULL values into a table with NOT NULL columns:
mysql> create table safetyfirst(
-> id int primary key not null auto_increment,
-> country (more...)
If you have thread_concurrency, innodb_additional_mem_pool_size or innodb_use_sys_malloc in one of your my.cnf or my.ini files please remove it at your next opportunity unless one of the unlikely exceptions applies.
Thread_concurrency is a setting for only Solaris that has no effect in recent Solaris versions like 11. For (more...)