InnoDB Strict Mode

XtraDB/InnoDB has a strict mode, in which certain cases fail with an error rather than proceed with a warning, similar to SQL strict mode.

Strict mode is disabled by default until MariaDB 10.2.2, but can be set with the innodb_strict_mode server system variable.

Strict mode is useful when using the ROW_FORMAT and KEY_BLOCK_SIZE clauses with CREATE TABLE, ALTER_TABLE and CREATE INDEX statements. If the specified KEY_BLOCK_SIZE is too small to contain a row and the strict mode is on, an error is returned by the statement.

Clauses that conflict, for example resulting in table compression being disabled when you may expect it to be enabled, will fail instead of proceed under strict mode.

Strict mode can be set at runtime, globally or per session.


Comments loading...