diff options
| author | Pjotr Prins | 2023-02-22 07:53:59 -0600 |
|---|---|---|
| committer | Pjotr Prins | 2023-02-22 07:53:59 -0600 |
| commit | 9a0198e9b23a1995ca5e23be6c06039b580c7123 (patch) | |
| tree | a8e94cfe3ca7e9e0598e1ef93652aaecb7a5cd5b /issues/database-not-responding.gmi | |
| parent | 0cd30159d70a3b0bd886cd6f04af7e78236df6c7 (diff) | |
| download | gn-gemtext-9a0198e9b23a1995ca5e23be6c06039b580c7123.tar.gz | |
Update documentation
Diffstat (limited to 'issues/database-not-responding.gmi')
| -rw-r--r-- | issues/database-not-responding.gmi | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi index 8928d08..8cb5656 100644 --- a/issues/database-not-responding.gmi +++ b/issues/database-not-responding.gmi @@ -294,6 +294,49 @@ MariaDB [db_webqtl]> SHOW VARIABLES LIKE '%timeout%'; If you set wait_timeout and interactive_timeout values they get reset after a while. +# Recent crash + +``` +| Max_used_connections | 1030 | +| Threads_connected | 1030 | + +show open tables where in_use > 1; + ++-----------+----------------+--------+-------------+ +| Database | Table | In_use | Name_locked | ++-----------+----------------+--------+-------------+ +| db_webqtl | ProbeFreeze | 182 | 0 | +| db_webqtl | ProbeSet | 3 | 0 | +| db_webqtl | ProbeSetXRef | 3 | 0 | +| db_webqtl | PublishFreeze | 7 | 0 | +| db_webqtl | Species | 94 | 0 | +| db_webqtl | Tissue | 94 | 0 | +| db_webqtl | ProbeSetFreeze | 3 | 0 | +| db_webqtl | InbredSet | 108 | 0 | +| db_webqtl | GenoFreeze | 7 | 0 | ++-----------+----------------+--------+-------------+ +``` + +``` +FLUSH NO_WRITE_TO_BINLOG TABLES + +Waiting for table flush SELECT confidentiality, AuthorisedUsers FROM ProbeSetFreeze WHERE Name = 'EL_BXDCDScWAT_0216' 0.000 + +Waiting for table flush SELECT DISTINCT Tissue.Name FROM ProbeFreeze,ProbeSetFreeze, InbredSet, Tissue, Species WHERE Speci 0.000 +``` + +Another one to check next time is + +``` +SHOW ENGINE INNODB STATUS +``` + +and + +``` +mariabackup --backup --kill-long-query-type=SELECT --kill-long-queries-timeout=120 +``` + # Monitor connections Use the general log as described in |