diff options
| author | Pjotr Prins | 2022-01-02 17:59:15 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2022-01-02 17:59:15 +0100 |
| commit | 6fb507bda0fc208e6626f94797b41ba62ef7cef2 (patch) | |
| tree | cb07fc4b7cf21f0fa2d532a22353b20757edc884 /topics/systems/mariadb/ProbeSetData.gmi | |
| parent | ba75c3857a6922a91dcd2bede7ab4e4603440ec9 (diff) | |
| download | gn-gemtext-6fb507bda0fc208e6626f94797b41ba62ef7cef2.tar.gz | |
innodb: add note for future work
Diffstat (limited to 'topics/systems/mariadb/ProbeSetData.gmi')
| -rw-r--r-- | topics/systems/mariadb/ProbeSetData.gmi | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/topics/systems/mariadb/ProbeSetData.gmi b/topics/systems/mariadb/ProbeSetData.gmi index 189a2eb..8b3c662 100644 --- a/topics/systems/mariadb/ProbeSetData.gmi +++ b/topics/systems/mariadb/ProbeSetData.gmi @@ -1,6 +1,15 @@ # ProbeSetData -This is by far the largest table (~100Gb). I need to add disk space to be able to host it on the NVME and move stuff around. Final move is GN2 code and we have over 400Gb free. +This is by far the largest table (~200Gb). I need to add disk space to be able to host it on the NVME and move stuff around. Final move is GN2 code and we have over 400Gb free. + +This time I failed porting to InnoDB. Next time: + +* [ ] Move database to large drive +* [ ] Run second instance of mariadb, upgrade too +* [ ] Export a small version of ISAM to ISAM +* [ ] Try different sizes of innodb exports +* [ ] Make conversion and test performance +* [ ] Muck out ibdata1 and transaction logs I disabled these and they need to be restored: |