#SET SESSION storage_engine='InnoDB'; #SET SESSION storage_engine='MEMORY'; SET SESSION storage_engine='BDB'; CREATE TABLE t_not_partitioned ( f_int1 BIGINT); CREATE TABLE t_partitioned ( f_int1 BIGINT) PARTITION BY HASH(f_int1) PARTITIONS 2; OPTIMIZE TABLE t_not_partitioned; OPTIMIZE TABLE t_partitioned; REPAIR TABLE t_not_partitioned EXTENDED; REPAIR TABLE t_partitioned EXTENDED;