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