diff options
| author | Pjotr Prins | 2021-12-31 13:16:21 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2021-12-31 13:16:21 +0100 |
| commit | da244b89c3ab716749e5d893efd418a3ef0155bc (patch) | |
| tree | 335cd1964ab60a312733e6b2b2a5020497f24e8a /topics/systems/mariadb/move-to-innodb.gmi | |
| parent | a5763ffd214f92ef7f39dde4f83565fbfc06e870 (diff) | |
| download | gn-gemtext-da244b89c3ab716749e5d893efd418a3ef0155bc.tar.gz | |
innodb
Diffstat (limited to 'topics/systems/mariadb/move-to-innodb.gmi')
| -rw-r--r-- | topics/systems/mariadb/move-to-innodb.gmi | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/topics/systems/mariadb/move-to-innodb.gmi b/topics/systems/mariadb/move-to-innodb.gmi index bb9c0d4..36fbc04 100644 --- a/topics/systems/mariadb/move-to-innodb.gmi +++ b/topics/systems/mariadb/move-to-innodb.gmi @@ -438,6 +438,12 @@ For those cases see bottom of move-to-innodb.gmi. OPTIMIZE NO_WRITE_TO_BINLOG TABLE MYTABLE; ``` +After running the optimiser rename the tables + +``` +RENAME TABLE orig TO orig_old, mytest TO orig; +``` + ### Check test ## ProbeSetXRef |