CREATE TABLE t1 (g MULTIPOINT NOT NULL) ENGINE=InnoDB STATS_PERSISTENT=0; INSERT INTO t1 VALUES (MultiPointFromText('MULTIPOINT(0 0,10 10,10 20,20 20)')); connect purge_control,localhost,root; START TRANSACTION WITH CONSISTENT SNAPSHOT; connection default; DELETE FROM t1; ALTER TABLE t1 ADD SPATIAL INDEX (g); disconnect purge_control; InnoDB 0 transactions not purged DROP TABLE t1;