--source include/have_innodb.inc CREATE TABLE t1 (a INT) ENGINE=InnoDB; CREATE TABLE t2 (b INT) ENGINE=InnoDB; INSERT INTO t1 VALUES (1),(2); INSERT INTO t2 VALUES (3),(4); OPTIMIZE TABLE t1, t2; drop table t1, t2;