SQL_MODE

Databases MySQL

SQL_MODE and storage engines

Ronald Bradford
March 9, 2012

I was again reminded why setting SQL_MODE is so important in any new MySQL environment. While performing benchmark tests on parallel backup features with a common InnoDB tablespace and per file tablespace, I inadvertently missed an important step in the data migration.

Databases MySQL Uncategorized

Why SQL_MODE is essential even when not perfect

Ronald Bradford
February 16, 2012

In a recent rant on Why I think SQL_MODE is useless… , I wanted to counteract this statement with why we MUST all use SQL_MODE, even with the inherit flaws.