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 | |
| parent | c546eb5662b67697788d6cea2c35dd50c7804f40 (diff) | |
| download | gn-gemtext-0cd30159d70a3b0bd886cd6f04af7e78236df6c7.tar.gz | |
On mariadb
| -rw-r--r-- | issues/database-not-responding.gmi | 19 | ||||
| -rw-r--r-- | tasks/pjotrp.gmi | 7 |
2 files changed, 25 insertions, 1 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'; +``` diff --git a/tasks/pjotrp.gmi b/tasks/pjotrp.gmi index 9f1d205..aa0ae55 100644 --- a/tasks/pjotrp.gmi +++ b/tasks/pjotrp.gmi @@ -28,7 +28,6 @@ Now * [ ] Check backups of etc etc. * [ ] GeneNetwork consortium * [+] Machine room HDDs -* [ ] Byron epigenetics paper Later @@ -41,6 +40,12 @@ Later * [ ] RISC-V * [+] DOI support GN (Paris) * [ ] Automate tux01 restart for GN2+GN3 services +* [ ] tux01 has unused 4TB spinning disk +* [ ] tux02 has unused 2x4TB spinning disks and 2TB nvme /dev/nvme0n1 on adapter + https://www.cyberciti.biz/faq/upgrade-update-samsung-ssd-firmware/ + apt-get install fwupd fwupdate + fwupdmgr get-devices + The previously problematic Samsung 980 Pro was basically using the 3B2QGXA7, and now Samsung has introduced a new 5B2QGXA7 firmware to fix the problem. The problem mainly affects the 2TB version of the 980 Pro ### Ongoing tasks |