diff options
| author | Pjotr Prins | 2023-02-17 08:39:41 -0600 |
|---|---|---|
| committer | Pjotr Prins | 2023-02-17 08:39:41 -0600 |
| commit | 79a6609a898badf763ca00cf657864b47153fb14 (patch) | |
| tree | 6b56e8ea586d52dc19c2d8cb4bb90c393860adb4 /issues/systems/mariadb | |
| parent | 161d0c43c4bd3387dbadc7c3170f64a4b5bc950a (diff) | |
| download | gn-gemtext-79a6609a898badf763ca00cf657864b47153fb14.tar.gz | |
Innodb move
Diffstat (limited to 'issues/systems/mariadb')
| -rw-r--r-- | issues/systems/mariadb/move-to-innodb.gmi | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi index 61de97d..13fecce 100644 --- a/issues/systems/mariadb/move-to-innodb.gmi +++ b/issues/systems/mariadb/move-to-innodb.gmi @@ -1023,6 +1023,16 @@ ALTER TABLE ProbeSetFreeze CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_gene This makes GN a bit snappier, it appears. Next to fix is the AccessLog because Gn1 writes to it. +So: + +``` +show create table TempData; +ALTER TABLE TempData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; +ALTER TABLE TempData ENGINE = InnoDB; +alter table TempData add primary key (Id); +show create table TempData; +``` + ## Tags * assigned: pjotr |