From 79a6609a898badf763ca00cf657864b47153fb14 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Fri, 17 Feb 2023 08:39:41 -0600
Subject: Innodb move

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

(limited to 'issues/systems')

diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi
index 61de97d..13fecce 100644
--- a/issues/systems/mariadb/move-to-innodb.gmi
+++ b/issues/systems/mariadb/move-to-innodb.gmi
@@ -1023,6 +1023,16 @@ ALTER TABLE ProbeSetFreeze CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_gene
 
 This makes GN a bit snappier, it appears. Next to fix is the AccessLog because Gn1 writes to it.
 
+So:
+
+```
+show create table TempData;
+ALTER TABLE TempData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+ALTER TABLE TempData ENGINE = InnoDB;
+alter table TempData add primary key (Id);
+show create table TempData;
+```
+
 ## Tags
 
 * assigned: pjotr
-- 
cgit v1.2.3