diff options
Diffstat (limited to 'issues')
| -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; ``` |