From 91fc825cc2cf516e2cd7315a98f483bcf5ee5247 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Sun, 28 May 2023 09:22:33 -0500
Subject: Note on utf8 conversion

---
 issues/slow-sql-query-for-xapian-indexing.gmi | 5 +++++
 tasks/pjotrp.gmi                              | 2 +-
 2 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/issues/slow-sql-query-for-xapian-indexing.gmi b/issues/slow-sql-query-for-xapian-indexing.gmi
index 914d1d1..3e5030c 100644
--- a/issues/slow-sql-query-for-xapian-indexing.gmi
+++ b/issues/slow-sql-query-for-xapian-indexing.gmi
@@ -7,6 +7,11 @@
 * status: in progress
 * keywords: slow query
 
+# Tasks
+
+* [ ] upgrade mariadb on production
+* [ ] switch character type on ProbeSet table from latin1/utf8mb3 to utf8mb4 (and any other tables) - depends on mariadb version
+
 # Description
 
 Since moving to innodb we have this very slow query:
diff --git a/tasks/pjotrp.gmi b/tasks/pjotrp.gmi
index 998f391..1448a65 100644
--- a/tasks/pjotrp.gmi
+++ b/tasks/pjotrp.gmi
@@ -42,7 +42,7 @@ Later
 => ./machine-room.gmi machine room
 
 * [ ] Fix mariadb index search - see
-=> slow-sq
+=> ../issues/slow-sql-query-for-xapian-indexing.gmi
 * [ ] Frontend for GN4MSK
 * [.] Check Tony's list and improve search for SNPs and Hs
 * [ ] GeneNetwork consortium (paper & CTC)
-- 
cgit v1.2.3