summaryrefslogtreecommitdiff
path: root/issues
diff options
context:
space:
mode:
authorPjotr Prins2023-02-19 09:48:10 -0600
committerPjotr Prins2023-02-19 09:48:12 -0600
commit0cd30159d70a3b0bd886cd6f04af7e78236df6c7 (patch)
tree55f1f5673d3e6ad98c250182c7b87f9254b1fc4c /issues
parentc546eb5662b67697788d6cea2c35dd50c7804f40 (diff)
downloadgn-gemtext-0cd30159d70a3b0bd886cd6f04af7e78236df6c7.tar.gz
On mariadb
Diffstat (limited to 'issues')
-rw-r--r--issues/database-not-responding.gmi19
1 files changed, 19 insertions, 0 deletions
diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi
index e842a89..8928d08 100644
--- a/issues/database-not-responding.gmi
+++ b/issues/database-not-responding.gmi
@@ -293,3 +293,22 @@ MariaDB [db_webqtl]> SHOW VARIABLES LIKE '%timeout%';
```
If you set wait_timeout and interactive_timeout values they get reset after a while.
+
+# Monitor connections
+
+Use the general log as described in
+
+```
+ALTER TABLE mysql.general_log ENGINE = MyISAM;
+ALTER TABLE mysql.general_log ADD INDEX (event_time);
+SET GLOBAL general_log = 'ON';
+SET GLOBAL log_output = 'TABLE';
+```
+
+and we start logging all connections and queries! Let this run for a while and we switch it off again for analysis.
+
+To stop logging
+
+```
+SET GLOBAL general_log = 'OFF';
+```