summaryrefslogtreecommitdiff
path: root/issues/systems/mariadb
diff options
context:
space:
mode:
authorPjotr Prins2023-03-08 10:56:20 +0100
committerPjotr Prins2023-03-08 10:56:20 +0100
commit292407ece02764f42f740708a22e1626359ef76b (patch)
tree72bea99abeab02ccf12bc2e0878a64d774e212d3 /issues/systems/mariadb
parent5586fc4f1ad5a3c410bc5183a8d9b9c1b81067c9 (diff)
downloadgn-gemtext-292407ece02764f42f740708a22e1626359ef76b.tar.gz
Innodb
Diffstat (limited to 'issues/systems/mariadb')
-rw-r--r--issues/systems/mariadb/move-to-innodb.gmi28
1 files changed, 20 insertions, 8 deletions
diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi
index dbf3918..315ffac 100644
--- a/issues/systems/mariadb/move-to-innodb.gmi
+++ b/issues/systems/mariadb/move-to-innodb.gmi
@@ -36,6 +36,14 @@ For every table
* [ ] Convert to innodb
* [ ] Convert to utf8 and utf_general_ci (don't use utf8mb, see below)
+## Tags
+
+* assigned: pjotr
+* type: enhancement, documentation
+* status: unclear
+* priority: medium
+* keywords: database, mariadb, innodb
+
## Report
With the SQL database we need to move from myisam to innodb format,
@@ -840,8 +848,7 @@ Some select statement and maybe a page of GN2.
### Create primary key
```
-ALTER TABLE MYTABLE
- ADD PRIMARY KEY(col1,col2);
+ALTER TABLE MYTABLE ADD PRIMARY KEY(Id);
```
### Create indices
@@ -1086,10 +1093,15 @@ alter table TempData add primary key (Id);
show create table TempData;
```
-## Tags
+## Disk space
-* assigned: pjotr
-* type: enhancement, documentation
-* status: unclear
-* priority: medium
-* keywords: database, mariadb, innodb
+I needed more disk space to move the largest tables note the new SSD disk is twice as slow as the old SSD:
+
+```
+/dev/nvme0n1p2:
+ Timing buffered disk reads: 364 MB in 3.00 seconds = 121.23 MB/sec
+/dev/nvme2n1p6:
+ Timing buffered disk reads: 760 MB in 3.00 seconds = 253.27 MB/sec
+```
+
+This is due to the caddy interface. Copying mariadb data is really slow. Meanwhile rsync shows a sustained 50Mbs to the new drive.