connection node_2; connection node_1; CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB; CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB; connection node_2; SELECT 1 FROM DUAL; 1 1 LOCK TABLE t2 WRITE; connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2; connection node_2a; OPTIMIZE TABLE t1,t2;; connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2; connection node_2b; REPAIR TABLE t1,t2;; connection node_2; SET SESSION wsrep_sync_wait = 0; connection node_1; INSERT INTO t2 VALUES (1); connection node_2; UNLOCK TABLES; connection node_2a; Table Op Msg_type Msg_text test.t1 optimize note Table does not support optimize, doing recreate + analyze instead test.t1 optimize status OK test.t2 optimize note Table does not support optimize, doing recreate + analyze instead test.t2 optimize status OK connection node_2b; Table Op Msg_type Msg_text test.t1 repair note The storage engine for the table doesn't support repair test.t2 repair note The storage engine for the table doesn't support repair DROP TABLE t1; DROP TABLE t2;