diff options
author | Pjotr Prins | 2023-05-28 09:18:18 -0500 |
---|---|---|
committer | Pjotr Prins | 2023-05-28 09:18:18 -0500 |
commit | df8c16f83dd1ff02da562c347566a91f5adf7808 (patch) | |
tree | 5e368d2f2520045998f59b35745f2217fdeb2c0c /issues/systems/mariadb/move-to-innodb.gmi | |
parent | b1ea3c04254b590b909b49cdecf35bb1b59824e0 (diff) | |
download | gn-gemtext-df8c16f83dd1ff02da562c347566a91f5adf7808.tar.gz |
mariadb indexing
Diffstat (limited to 'issues/systems/mariadb/move-to-innodb.gmi')
-rw-r--r-- | issues/systems/mariadb/move-to-innodb.gmi | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi index fdd3c28..4218c4f 100644 --- a/issues/systems/mariadb/move-to-innodb.gmi +++ b/issues/systems/mariadb/move-to-innodb.gmi @@ -583,20 +583,16 @@ Turned out simple utf8 worked: ALTER TABLE ProbeSet CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ``` -and utf8mb is not recommended. We'll need fix that FIXME. See +and utf8mb3 is not recommended. We'll need fix that FIXME. See => https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci -pjotrp 16 Oct 2019 at 09:24 (edited) - Full text search is the least straightforward, see and Now for ProbeSet - one of the critical locked tables we need this. -pjotrp 15 Oct 2019 at 16:38 (edited) - ``` time mysqlcheck -c -u webqtlout -pwebqtlout db_webqtl db_webqtl.Docs |