From 91fc825cc2cf516e2cd7315a98f483bcf5ee5247 Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Sun, 28 May 2023 09:22:33 -0500 Subject: Note on utf8 conversion --- issues/slow-sql-query-for-xapian-indexing.gmi | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'issues') 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: -- cgit v1.2.3