DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a , b ) ENGINE= KEY_BLOCK_SIZE=8; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL ) ENGINE= DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=8 ALTER TABLE t1 KEY_BLOCK_SIZE=1; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL ) ENGINE= DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1 DROP TABLE t1;