diff options
| author | Frederick Muriuki Muriithi | 2022-03-16 08:27:39 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-03-16 08:27:39 +0300 |
| commit | a7b9dcbe3c30da701c4c47f570f3203c8ed66525 (patch) | |
| tree | 4b2508e608a7daf7ec4b0fb26cd45edb59c6d991 /topics/systems/mariadb/move-to-innodb.gmi | |
| parent | e8e876fd49c8a52944baec0b9313659917ac9a97 (diff) | |
| download | gn-gemtext-a7b9dcbe3c30da701c4c47f570f3203c8ed66525.tar.gz | |
Tag and Prioritise more issues
Diffstat (limited to 'topics/systems/mariadb/move-to-innodb.gmi')
| -rw-r--r-- | topics/systems/mariadb/move-to-innodb.gmi | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/topics/systems/mariadb/move-to-innodb.gmi b/topics/systems/mariadb/move-to-innodb.gmi index b29173e..134a50a 100644 --- a/topics/systems/mariadb/move-to-innodb.gmi +++ b/topics/systems/mariadb/move-to-innodb.gmi @@ -1,3 +1,5 @@ +# MariaDB: Move to InnoDB Engine + We are going to move from myisam to innodb. Penguin2 has been happily running innodb for some time. Main problem are fulltext columns, the text from Trello is captured below. This is for the following tables @@ -581,3 +583,12 @@ On Penguin2 we are already runing ProbeSetData as ``` which is pretty massive! It includes the index, which is 180G, so the difference is not that great. Also we should try a 4kb page size. Also make sure to enable innodb_file_per_table. + + +## Tags + +* assigned: pjotr +* type: enhancement, documentation +* status: unclear +* priority: medium +* keywords: database, mariadb, innodb |