From aa71edbc3f96e99b17c9e831dec67a77f104f162 Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Fri, 31 Dec 2021 16:31:16 +0100 Subject: innodb --- topics/systems/mariadb/ProbeSetData.gmi | 2 ++ 1 file changed, 2 insertions(+) diff --git a/topics/systems/mariadb/ProbeSetData.gmi b/topics/systems/mariadb/ProbeSetData.gmi index 0e077ad..9fb8306 100644 --- a/topics/systems/mariadb/ProbeSetData.gmi +++ b/topics/systems/mariadb/ProbeSetData.gmi @@ -106,6 +106,8 @@ MariaDB [db_webqtl]> select max(Id) from ProbeSetData; For StrainID MediumInt is a better fit with unsigned range is 0 to 16777215 and Id should be a INT (instead of BIGINT for the time being). That will make the table+indices smaller and faster. +When a value overflows MariaDB will throw an error. So even if we grow out of values we can quickly resize the table in, say, 10 years. That is, if we are still using SQL. + ### Check GN1,2,3 code for use of table ``` -- cgit v1.2.3