diff options
| -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 |