From da244b89c3ab716749e5d893efd418a3ef0155bc Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Fri, 31 Dec 2021 13:16:21 +0100
Subject: innodb

---
 topics/systems/mariadb/move-to-innodb.gmi | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'topics/systems/mariadb/move-to-innodb.gmi')

diff --git a/topics/systems/mariadb/move-to-innodb.gmi b/topics/systems/mariadb/move-to-innodb.gmi
index bb9c0d4..36fbc04 100644
--- a/topics/systems/mariadb/move-to-innodb.gmi
+++ b/topics/systems/mariadb/move-to-innodb.gmi
@@ -438,6 +438,12 @@ For those cases see bottom of move-to-innodb.gmi.
 OPTIMIZE NO_WRITE_TO_BINLOG TABLE MYTABLE;
 ```
 
+After running the optimiser rename the tables
+
+```
+RENAME TABLE orig TO orig_old, mytest TO orig;
+```
+
 ### Check test
 
 ## ProbeSetXRef
-- 
cgit v1.2.3