From 6fb507bda0fc208e6626f94797b41ba62ef7cef2 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Sun, 2 Jan 2022 17:59:15 +0100
Subject: innodb: add note for future work

---
 topics/systems/mariadb/ProbeSetData.gmi | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'topics')

diff --git a/topics/systems/mariadb/ProbeSetData.gmi b/topics/systems/mariadb/ProbeSetData.gmi
index 189a2eb..8b3c662 100644
--- a/topics/systems/mariadb/ProbeSetData.gmi
+++ b/topics/systems/mariadb/ProbeSetData.gmi
@@ -1,6 +1,15 @@
 # ProbeSetData
 
-This is by far the largest table (~100Gb). I need to add disk space to be able to host it on the NVME and move stuff around. Final move is GN2 code and we have over 400Gb free.
+This is by far the largest table (~200Gb). I need to add disk space to be able to host it on the NVME and move stuff around. Final move is GN2 code and we have over 400Gb free.
+
+This time I failed porting to InnoDB. Next time:
+
+* [ ] Move database to large drive
+* [ ] Run second instance of mariadb, upgrade too
+* [ ] Export a small version of ISAM to ISAM
+* [ ] Try different sizes of innodb exports
+* [ ] Make conversion and test performance
+* [ ] Muck out ibdata1 and transaction logs
 
 I disabled these and they need to be restored:
 
-- 
cgit v1.2.3