summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--issues/slow-sql-query-for-xapian-indexing.gmi5
-rw-r--r--tasks/pjotrp.gmi2
2 files changed, 6 insertions, 1 deletions
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)