diff options
| author | Pjotr Prins | 2023-03-01 07:45:18 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2023-03-01 07:45:22 +0100 |
| commit | 36b447818723ae25d79c3b8250e892ae0fe9af74 (patch) | |
| tree | a1fa2f3f545608bf956f4201ec810d723f603825 | |
| parent | 76d222c46b44ed66bd34aa323d22789389f887cc (diff) | |
| download | gn-gemtext-36b447818723ae25d79c3b8250e892ae0fe9af74.tar.gz | |
Databases
| -rw-r--r-- | issues/database-not-responding.gmi | 2 | ||||
| -rw-r--r-- | issues/systems/mariadb/move-to-innodb.gmi | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi index 8cb5656..5531e31 100644 --- a/issues/database-not-responding.gmi +++ b/issues/database-not-responding.gmi @@ -306,7 +306,7 @@ show open tables where in_use > 1; | Database | Table | In_use | Name_locked | +-----------+----------------+--------+-------------+ | db_webqtl | ProbeFreeze | 182 | 0 | -| db_webqtl | ProbeSet | 3 | 0 | +| db_webqtl | ProbeSet | 3 | 0 | <- text, still latin1 | db_webqtl | ProbeSetXRef | 3 | 0 | | db_webqtl | PublishFreeze | 7 | 0 | | db_webqtl | Species | 94 | 0 | diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi index 13fecce..72520c5 100644 --- a/issues/systems/mariadb/move-to-innodb.gmi +++ b/issues/systems/mariadb/move-to-innodb.gmi @@ -1027,8 +1027,8 @@ 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 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; alter table TempData add primary key (Id); show create table TempData; ``` |