set global innodb_file_per_table=off; set global innodb_file_format=0; create table t1(a int primary key) engine=innodb row_format=dynamic; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_FORMAT' create table t1(a int primary key) engine=innodb row_format=redundant; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT drop table t1; create table t1(a int primary key) engine=innodb row_format=compact; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT drop table t1; create table t1(a int primary key) engine=innodb key_block_size=9; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' create table t1(a int primary key) engine=innodb key_block_size=1 row_format=redundant; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' set global innodb_file_per_table=on; create table t1(a int primary key) engine=innodb key_block_size=1 row_format=redundant; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' set global innodb_file_format=1; create table t1(a int primary key) engine=innodb key_block_size=1 row_format=redundant; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_FORMAT' create table t1(a int primary key) engine=innodb key_block_size=1 row_format=compact; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT KEY_BLOCK_SIZE=1 drop table t1; create table t1(a int primary key) engine=innodb key_block_size=1; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1 drop table t1; create table t1(a int not null, b text, index(b(10))) engine=innodb key_block_size=1; create table t2(b text)engine=innodb; insert into t2 values(concat('1abcdefghijklmnopqrstuvwxyz', repeat('A',5000))); insert into t1 select 1, b from t2; commit; begin; update t1 set b=repeat('B',100); select a,left(b,40) from t1 natural join t2; a left(b,40) 1 1abcdefghijklmnopqrstuvwxyzAAAAAAAAAAAAA rollback; select a,left(b,40) from t1 natural join t2; a left(b,40) 1 1abcdefghijklmnopqrstuvwxyzAAAAAAAAAAAAA drop table t1; drop table t2; set global innodb_file_per_table=0; set global innodb_file_format=0;