From a7b9dcbe3c30da701c4c47f570f3203c8ed66525 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Wed, 16 Mar 2022 08:27:39 +0300
Subject: Tag and Prioritise more issues

---
 topics/systems/mariadb/ProbeData.gmi      | 10 ++++++++++
 topics/systems/mariadb/ProbeSE.gmi        | 12 ++++++++++++
 topics/systems/mariadb/ProbeSetData.gmi   | 10 ++++++++++
 topics/systems/mariadb/ProbeSetXRef.gmi   | 10 ++++++++++
 topics/systems/mariadb/cleanup.gmi        | 10 ++++++++++
 topics/systems/mariadb/mariadb.gmi        |  3 ++-
 topics/systems/mariadb/move-to-innodb.gmi | 11 +++++++++++
 7 files changed, 65 insertions(+), 1 deletion(-)

(limited to 'topics/systems/mariadb')

diff --git a/topics/systems/mariadb/ProbeData.gmi b/topics/systems/mariadb/ProbeData.gmi
index b613784..c339571 100644
--- a/topics/systems/mariadb/ProbeData.gmi
+++ b/topics/systems/mariadb/ProbeData.gmi
@@ -1,4 +1,14 @@
+# ProbeData
 
+## Tags
+
+* assigned: pjotrp, aruni
+* status: unclear
+* priority: medium
+* type: enhancement
+* keywords: database, mariadb, innodb, ProbeData
+
+## Description
 
 Probe level data is used to examine the correlation structure among the
 N probes that have the same nominal target. Sometimes several probes
diff --git a/topics/systems/mariadb/ProbeSE.gmi b/topics/systems/mariadb/ProbeSE.gmi
index f9aa670..2c36514 100644
--- a/topics/systems/mariadb/ProbeSE.gmi
+++ b/topics/systems/mariadb/ProbeSE.gmi
@@ -1,3 +1,15 @@
+# ProbeSE
+
+## Tags
+
+* assigned: pjotrp
+* status: unclear
+* priority: medium
+* type: enhancement
+* keywords: database, mariadb, innodb, ProbeSE
+
+## Description
+
 Zach pointed out that ProbeSE is used on GN1 with
 
 => http://gn1.genenetwork.org/webqtl/main.py?FormID=showProbeInfo&database=HC_M2_0606_P&ProbeSetID=1427571_at&CellID=None&RISet=BXD&incparentsf1=ON
diff --git a/topics/systems/mariadb/ProbeSetData.gmi b/topics/systems/mariadb/ProbeSetData.gmi
index 63e7912..672b64c 100644
--- a/topics/systems/mariadb/ProbeSetData.gmi
+++ b/topics/systems/mariadb/ProbeSetData.gmi
@@ -1,5 +1,15 @@
 # ProbeSetData
 
+## Tags
+
+* assigned: pjotrp
+* status: unclear
+* priority: medium
+* type: enhancement
+* keywords: database, mariadb, innodb
+
+## Description
+
 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:
diff --git a/topics/systems/mariadb/ProbeSetXRef.gmi b/topics/systems/mariadb/ProbeSetXRef.gmi
index d8981a5..cdf08f4 100644
--- a/topics/systems/mariadb/ProbeSetXRef.gmi
+++ b/topics/systems/mariadb/ProbeSetXRef.gmi
@@ -1,3 +1,13 @@
+# ProbeSetXRef
+
+## Tags
+
+* keywords: ProbeSetXRef, database, mariadb, innodb
+* type: enhancement, documentation
+* assigned: pjotrp
+* status: unclear
+* priority: medium
+
 ## Table ProbeSetXRef
 
 Juggling indexes and transforming to InnoDB led to a massive speed increase for typical ProbeSetXRef queries. Global search for brca2 went down from 13s to 4s! Try
diff --git a/topics/systems/mariadb/cleanup.gmi b/topics/systems/mariadb/cleanup.gmi
index c034fbc..0639e40 100644
--- a/topics/systems/mariadb/cleanup.gmi
+++ b/topics/systems/mariadb/cleanup.gmi
@@ -1,4 +1,14 @@
+# Clean Up
 
+## Tags
+
+* assigned: pjotrp, robw
+* status: unclear
+* priority: unclear
+* type: database administration
+* keywords: database, mariadb
+
+## Description
 
 Find all larger tables
 
diff --git a/topics/systems/mariadb/mariadb.gmi b/topics/systems/mariadb/mariadb.gmi
index c2c927b..0cbd0e7 100644
--- a/topics/systems/mariadb/mariadb.gmi
+++ b/topics/systems/mariadb/mariadb.gmi
@@ -4,7 +4,8 @@ Here we capture some common actions
 
 ## Tags
 
-* info
+* type: info, documentation
+* keywords: mariadb, systems
 
 ## Check the transaction logs
 
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
-- 
cgit v1.2.3