diff options
| author | Pjotr Prins | 2023-05-28 09:22:33 -0500 |
|---|---|---|
| committer | Pjotr Prins | 2023-05-28 09:22:33 -0500 |
| commit | 91fc825cc2cf516e2cd7315a98f483bcf5ee5247 (patch) | |
| tree | 54cb069c516e0af7011f10e592bb9fe02afd2779 | |
| parent | df8c16f83dd1ff02da562c347566a91f5adf7808 (diff) | |
| download | gn-gemtext-91fc825cc2cf516e2cd7315a98f483bcf5ee5247.tar.gz | |
Note on utf8 conversion
| -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) |