diff options
| author | Pjotr Prins | 2023-02-15 09:53:43 -0600 |
|---|---|---|
| committer | Pjotr Prins | 2023-02-15 09:55:45 -0600 |
| commit | ea9b2f14836158def6c524152c77c542124f428a (patch) | |
| tree | c45f2e216a0d8c4bbbc69511da0d331acec10fc5 | |
| parent | c917dc541b60aab15d086612e420dd9fd9efb9cb (diff) | |
| download | gn-gemtext-ea9b2f14836158def6c524152c77c542124f428a.tar.gz | |
notes on db
| -rw-r--r-- | issues/database-not-responding.gmi | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi index dec9b1e..e842a89 100644 --- a/issues/database-not-responding.gmi +++ b/issues/database-not-responding.gmi @@ -77,6 +77,24 @@ MariaDB [db_webqtl]> show open tables where in_use > 1; 11 rows in set (0.001 sec) ``` +``` +MariaDB [db_webqtl]> show open tables where in_use > 1; ++-----------+----------------+--------+-------------+ +| Database | Table | In_use | Name_locked | ++-----------+----------------+--------+-------------+ +| db_webqtl | ProbeFreeze | 191 | 0 | +| db_webqtl | ProbeSet | 6 | 0 | +| db_webqtl | ProbeSetXRef | 6 | 0 | +| db_webqtl | PublishFreeze | 13 | 0 | +| db_webqtl | Species | 106 | 0 | +| db_webqtl | Tissue | 106 | 0 | +| db_webqtl | ProbeSetFreeze | 6 | 0 | +| db_webqtl | InbredSet | 132 | 0 | +| db_webqtl | GenoFreeze | 13 | 0 | ++-----------+----------------+--------+-------------+ +9 rows in set (0.001 sec) +``` + In the error log we seeing a lot of ``` |