diff options
| author | Pjotr Prins | 2021-12-30 06:52:28 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2021-12-30 06:52:28 +0100 |
| commit | 995507d63185c93e20e7c5ff905914535eb11e33 (patch) | |
| tree | 53e9399a9f946e447a22dc4481014e87e1754b6a /topics/systems/mariadb/move-to-innodb.gmi | |
| parent | 0398a7c5f39b546dacaee54562ac23391ddb752b (diff) | |
| download | gn-gemtext-995507d63185c93e20e7c5ff905914535eb11e33.tar.gz | |
Innodb and ProbeSetXREf
Diffstat (limited to 'topics/systems/mariadb/move-to-innodb.gmi')
| -rw-r--r-- | topics/systems/mariadb/move-to-innodb.gmi | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/topics/systems/mariadb/move-to-innodb.gmi b/topics/systems/mariadb/move-to-innodb.gmi index f93aace..f5011cb 100644 --- a/topics/systems/mariadb/move-to-innodb.gmi +++ b/topics/systems/mariadb/move-to-innodb.gmi @@ -348,6 +348,11 @@ Prototocol from Every table update has to follow the template: +### Check recent backups + +* [ ] ascertain there is a backup +* [ ] copy original files + ### Check table structure ``` @@ -366,6 +371,7 @@ select count(*) from MYTABLE; ``` rg MYTABLE --color=always |less -R +rg MYTABLE --type=py -l|fzf --preview="rg --color=always -A 20 MYTABLE {}" --preview-window=right:85%:wrap ``` ### Create test @@ -380,6 +386,12 @@ ALTER TABLE MYTABLE ``` ### Create indices + +``` +SHOW INDEX FROM MYTABLE; +DROP INDEX ProbeSetId ON MYTABLE; +``` + ### Convert to innodb ``` |