diff options
| -rw-r--r-- | issues/slow-sql-query-for-xapian-indexing.gmi | 5 | ||||
| -rw-r--r-- | tasks/pjotrp.gmi | 2 |
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) |