From ea9b2f14836158def6c524152c77c542124f428a Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Wed, 15 Feb 2023 09:53:43 -0600
Subject: notes on db

---
 issues/database-not-responding.gmi | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'issues')

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
 
 ```
-- 
cgit v1.2.3