From 8746beb2bbc61ed676e9540f896a5474cd60eaf8 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Mon, 29 May 2023 07:41:32 -0500
Subject: Reduced issue priority. Task mostly done.

---
 issues/slow-sql-query-for-xapian-indexing.gmi | 4 +++-
 tasks/pjotrp.gmi                              | 3 ++-
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/issues/slow-sql-query-for-xapian-indexing.gmi b/issues/slow-sql-query-for-xapian-indexing.gmi
index 3e5030c..882e1c0 100644
--- a/issues/slow-sql-query-for-xapian-indexing.gmi
+++ b/issues/slow-sql-query-for-xapian-indexing.gmi
@@ -1,9 +1,11 @@
 # Slow query
 
+Essentially two tables were utf8 (= utf8mb3). The others are utf8mb4. When comparing text fields mariadb can't optimize because it is translating utf8mb3 for every comparison. Changing the table and indices to utf8mb4 or latin1 (on production) fixed it.
+
 # Tags
 
 * assigned: pjotrp, aruni
-* priority: high
+* priority: medium
 * status: in progress
 * keywords: slow query
 
diff --git a/tasks/pjotrp.gmi b/tasks/pjotrp.gmi
index 1448a65..1847d32 100644
--- a/tasks/pjotrp.gmi
+++ b/tasks/pjotrp.gmi
@@ -41,8 +41,9 @@ Later
 
 => ./machine-room.gmi machine room
 
-* [ ] Fix mariadb index search - see
+* [+] Fix mariadb index search - need to upgrade mariadb, see
 => ../issues/slow-sql-query-for-xapian-indexing.gmi
+* [+] move backup dirs on tux01 to a larger partition (from export3 to export2)
 * [ ] Frontend for GN4MSK
 * [.] Check Tony's list and improve search for SNPs and Hs
 * [ ] GeneNetwork consortium (paper & CTC)
-- 
cgit v1.2.3