create table t ( b point not null,d point not null, spatial key (d),spatial key (b) ) engine=innodb stats_persistent=0; InnoDB 0 transactions not purged drop table t;