diff options
| author | Pjotr Prins | 2023-02-19 09:48:10 -0600 |
|---|---|---|
| committer | Pjotr Prins | 2023-02-19 09:48:12 -0600 |
| commit | 0cd30159d70a3b0bd886cd6f04af7e78236df6c7 (patch) | |
| tree | 55f1f5673d3e6ad98c250182c7b87f9254b1fc4c /issues/database-not-responding.gmi | |
| parent | c546eb5662b67697788d6cea2c35dd50c7804f40 (diff) | |
| download | gn-gemtext-0cd30159d70a3b0bd886cd6f04af7e78236df6c7.tar.gz | |
On mariadb
Diffstat (limited to 'issues/database-not-responding.gmi')
| -rw-r--r-- | issues/database-not-responding.gmi | 19 |
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'; +``` |