diff options
| author | Pjotr Prins | 2023-03-13 11:58:05 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2023-03-13 11:58:05 +0100 |
| commit | b73c798bc7b1278b18bb74137827ddddba3637a6 (patch) | |
| tree | 183d63134daab65b26f98e578c8e6e0242985207 /issues/systems/mariadb/ProbeSetData.gmi | |
| parent | 7223e7514b98f270f7717f48307a5114d7bf0e11 (diff) | |
| download | gn-gemtext-b73c798bc7b1278b18bb74137827ddddba3637a6.tar.gz | |
ProbeSetData info - also copied from gn3 repo
Diffstat (limited to 'issues/systems/mariadb/ProbeSetData.gmi')
| -rw-r--r-- | issues/systems/mariadb/ProbeSetData.gmi | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/issues/systems/mariadb/ProbeSetData.gmi b/issues/systems/mariadb/ProbeSetData.gmi index 9fceea9..f3ac37c 100644 --- a/issues/systems/mariadb/ProbeSetData.gmi +++ b/issues/systems/mariadb/ProbeSetData.gmi @@ -369,9 +369,11 @@ Now the table is 58Gb without indices. Convert to innodb and add indices ``` CREATE INDEX id_index ON ProbeSetData(Id); +CREATE INDEX strainid_index ON ProbeSetData(StrainId); ALTER TABLE ProbeSetData ENGINE = InnoDB; ``` +The conversion to InnoDB, annoyingly, leads to an exceedingly large file. I think we'll keep the myisam version for ProbeSetData. It does not do text comparison, so we should see no slow downs mixing with InnoDB. From this exercise I know we can reduce the size a little. Also ProbeSet can probably be made smaller by combining id+strainid where id is dataset id and perhaps even reducing the value size by compressing it into a smaller float. ## Notes |